简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Backend Development > PHP Tutorial > body text

求一句SQL话语

WBOY
Release： 2016-06-13 13:25:02
Original
813 people have browsed it

求一句SQL语句！
现在有一个video表，里面有id,title,type,time等列名，现要根据time排序选出每种type的前10个记录，SQL语句如何写呢？

------解决方案--------------------

探讨

他要按time排序选,而且应该是倒序(虽然他没说),所以我猜是

SELECT *
FROM video t
WHERE 10 > (
SELECT COUNT( * )
FROM video
WHERE type=t.type
AND time>t.ti……
Related labels：
select time type video where
source：php.cn
Previous article： phpcms 源码解析-模板发动机 Next article： PHP开发札记系列（XAMPP+PhpEclipse+XDebug）
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
JavaScript hover events on vendor-specific pseudo-elements I have the following htmlinput tag. $("input[type='range']::-webkit-slider-thumb"...
From 2024-04-06 15:35:24
0
1
274
Even after clearing, the value of my file input remains As you can see in the screenshot. I select a file, keep the popup without refreshing the p...
From 2024-04-06 15:44:52
0
1
384
Display nested array of objects in HTML table by iterating I have the following input containing an array of nested objects. summary is the parent ob...
From 2024-04-05 14:11:42
0
1
1373
NumberInput mouse wheel handling ignores capture phase event filtering Very short version: I'm a bit stuck and don't quite understand why this code does indeed i...
From 2024-04-05 12:21:04
0
1
1387
Add the Endpoint _header attribute to the JSON response object I'm testing pulling data from a remote endpoint service (npoint.io). When I get back the r...
From 2024-04-05 10:35:39
0
1
1376
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！