c# 排序简单问题 SQL语句

显示全部楼层 · 2009-7-8 18:11:47

如果webid是主键，可以用减法，即得到所有count>=(webid=5的count)的记录数，再减去count=(webid=5的count)and (webid>5)的记录数即可。如果不是，最好用游标：以下st_questionid用webid代替，st_courseid用count代替：declare @cnt int,@id int,@cid intset @id=-1set @cnt=0declare mycursor cursor for select st_questionid, st_courseid from st_questioninfo order by st_courseid descopen my...

千问 · 2009-7-8 18:11:47

先在SQL中出来数据，再在C#后台中取行号就行了。你如果想在SQL中取行号那就用存储过程。...

千问 · 2009-7-8 18:11:47

SELECT ROW_NUMBER() OVER (ORDER BY id DESC) rid, * FROM [User] u...

千问 · 2009-7-8 18:11:47

select sum(wedid) where Count > (select Count from websites where webid = 5) from websites....

千问 · 2009-7-8 18:11:47

select rid from (select row_number()over(order by count asc) as rid, * from websites) where webid=5...