现有一个表记录数不定,通过后台添加。
例如有记录100条,现在需要取出第100条、99条、98条、97条四条,在页面上面显示。
并不能用Select Top 4 from [event] order by eventid desc
需要是:
dadcep_db.selectcommand=new sqlcommand("select * from [event] where eventid='100'",concepia_db)
dadcep_db.fill(dstcep_db,"events_one")里面得SQL语句分别为:
select * from [event] where eventid=100
select * from [event] where eventid=99
select * from [event] where eventid=98
select * from [event] where eventid=97
这样请问如何实现,因为添加记录得eventid数是未知得??谢谢
例如有记录100条,现在需要取出第100条、99条、98条、97条四条,在页面上面显示。
并不能用Select Top 4 from [event] order by eventid desc
需要是:
dadcep_db.selectcommand=new sqlcommand("select * from [event] where eventid='100'",concepia_db)
dadcep_db.fill(dstcep_db,"events_one")里面得SQL语句分别为:
select * from [event] where eventid=100
select * from [event] where eventid=99
select * from [event] where eventid=98
select * from [event] where eventid=97
这样请问如何实现,因为添加记录得eventid数是未知得??谢谢
(select count(1) from [event] where eventid>=A.enentid)<=4
select top 2 * from [event] order by eventid desc
) as t order by eventid select top 1 * from (
select top 3 * from [event] order by eventid desc
) as t order by eventid
select top 1 * from (
select top 4 * from [event] order by eventid desc
) as t order by eventid
同样非常感谢zsforever(虎虎),小妹再此谢了另外as t order by 中的as t不太懂?