请高手帮忙,求一条SQL 语句.

[wubaowang]

本人初学SQL
如下,有没有比个方法更好的.效率高的.可以查询.
select *,
(select count(*) from
(select * from wubw where wNum=3) s
where ID <=a.ID) as fid
from wubw a
where (select count(*) from
(select * from wubw where wNum=3) s
where ID <=a.ID)=10

[dawugui]

这句话我咋看咋别扭,你给个数据和结果,我们帮你看看.

[dobear_0922]

select *,10 
from wubw a 
where (select count(*) from  
(select * from wubw where wNum=3) s  
where ID  <=a.ID)=10

[dobear_0922]

select *,10 
from wubw a 
where (select count(1) from  
(select 1 from wubw where wNum=3) s  
where ID  <=a.ID)=10

[yxh198358]

是啊，写的比较烦琐！

[WangZWang]

--试试
Select * ,10 as fid from wubw as a
where (Select count(*) from wubw where wNum=3 and ID<=a.ID)=10

[dobear_0922]

上面那个错了

select *,10 
from wubw a 
where (select count(1) from  
(select ID from wubw where wNum=3) s  
where ID  <=a.ID)=10

[elvis_gao]

select *, 
    10 as fid  
from wubw a 
where (select count(*) from  
(select * from wubw where wNum=3) s  
where ID  <=a.ID)=10

[wubaowang]

查询结果显示:
ID从小到大排序
显示第10行
wNum=3

[dobear_0922]

查询结果显示:
ID从小到大排序
显示第10行
wNum=3
-------------

select * from wubw a
where wNum=3 and (select count(1) from wubw where wNum=3 and ID<=a.ID)=10

[WangZWang]

--或者

Select top 1 *,10 as fid from (
Select top 10 * from wubw where wNum=3
 Order by ID ) t Order by ID desc