SQL将指定表排序并输出满足条件的记录是第几条
Charles Chan @ 27 Dec 2011 #SQL
用于获取名次等的查询功能。
Select @result=fieldx from(
Select *, ROW_NUMBER() over (order by fieldy desc) as fieldx from table where xxx
) AS T
Where T.xx = xx
Charles Chan @ 27 Dec 2011 #SQL
用于获取名次等的查询功能。
Select @result=fieldx from(
Select *, ROW_NUMBER() over (order by fieldy desc) as fieldx from table where xxx
) AS T
Where T.xx = xx