SELECT top 20 id, title, Idate FROM news where id not in (SELECT top 10 id, title, Idate FROM news ORDER BY Idate DESC) ORDER BY Idate DESC
SELECT top 10 id, title, Idate FROM news where id not in (SELECT top 10 id, title, Idate FROM news ORDER BY Idate DESC) ORDER BY Idate DESC
SELECT top 10 id, title, Idate FROM news where id not in (SELECT top 10 id, title, Idate FROM news ORDER BY Idate DESC) ORDER BY Idate DESC
没有行号,就是麻烦 oracle和db2都有行号
SELECT top 10 id, title, Idate FROM news where id not in (SELECT top 10 id FROM news ORDER BY Idate DESC) ORDER BY Idate DESC
select top 10 * from news where id > all(select top 10 id from news order by id) order by id
select top 10 id, title, Idate from news where id in (SELECT top 10 id, title, Idate FROM news ORDER BY Idate DESC) order by Idate Desc
SELECT top 20 id, title, Idate FROM news where id not in (SELECT top 10 id FROM news ORDER BY Idate DESC) ORDER BY Idate DESC看了你两个问题,感觉你是要做存储过程吧:)
SELECT top 20 id, title, Idate FROM news where id not in (SELECT top 10 id, title, Idate FROM news ORDER BY Idate DESC) ORDER BY Idate DESC 上面兄台正解。。就这是分页的思想
SELECT top 20 id, title, Idate FROM news where id not in (select top 10 id from news) ORDER BY Idate DESC
SELECT top 10 id, title, Idate FROM news where id not in (SELECT top 10 id FROM news ORDER BY Idate DESC) ORDER BY Idate DESC 这个才是正解
----------------------------------------------------------------------------- 方法:先按照顺序取前20条记录,然后在选择的记录基础上倒序取前10条,正好是10-20条记录SELECT TOP 10 * FROM (SELECT TOP 20 * FROM news ORDER BY ID ASC) as a ORDER BY ID DESC -----------------------------------------------------------------------------------
------------------------------------------------------ select top 10 id, title, Idate from news where id in (SELECT top 20 id FROM news ORDER BY Idate DESC) order by Idate Desc --------------------------------------------------
SELECT TOP 10 * FROM (SELECT TOP 20 * FROM news ORDER BY ID ASC) as a ORDER BY ID DESC
楼上说的对,不过 not in 实在太耗费资源,大的库就不要用了
SELECT TOP 10 * FROM (SELECT TOP 20 * FROM news ORDER BY ID ASC) as a ORDER BY ID DESC
where id not in (SELECT top 10 id, title, Idate FROM news ORDER BY Idate DESC)
ORDER BY Idate DESC
where id not in (SELECT top 10 id, title, Idate FROM news ORDER BY Idate DESC)
ORDER BY Idate DESC
oracle和db2都有行号
where id not in
(SELECT top 10 id FROM news ORDER BY Idate DESC)
ORDER BY Idate DESC
(SELECT top 10 id, title, Idate
FROM news
ORDER BY Idate DESC) order by Idate Desc
where id not in (SELECT top 10 id FROM news ORDER BY Idate DESC)
ORDER BY Idate DESC看了你两个问题,感觉你是要做存储过程吧:)
where id not in (SELECT top 10 id, title, Idate FROM news ORDER BY Idate DESC)
ORDER BY Idate DESC
上面兄台正解。。就这是分页的思想
FROM news
where id not in (select top 10 id from news)
ORDER BY Idate DESC
where id not in
(SELECT top 10 id FROM news ORDER BY Idate DESC)
ORDER BY Idate DESC
这个才是正解
方法:先按照顺序取前20条记录,然后在选择的记录基础上倒序取前10条,正好是10-20条记录SELECT TOP 10 *
FROM (SELECT TOP 20 *
FROM news
ORDER BY ID ASC) as a
ORDER BY ID DESC
-----------------------------------------------------------------------------------
select top 10 id, title, Idate from news where id in
(SELECT top 20 id FROM news
ORDER BY Idate DESC) order by Idate Desc
--------------------------------------------------
FROM (SELECT TOP 20 *
FROM news
ORDER BY ID ASC) as a
ORDER BY ID DESC
FROM (SELECT TOP 20 *
FROM news
ORDER BY ID ASC) as a
ORDER BY ID DESC