如何查询出价格为第三大
Create table Cost
(
ID int primary key,
cost int not null
)
insert into Cost values(1,200)
insert into cost values(2,300)
insert into cost values(3,150)
insert into cost values(4,160)
结果如下:
-----------------
ID Cost
4 160
[解决办法]
select * from Cost as tmp
where (select count(*) from Cost where cost> =tmp.cost)=3
--result
ID cost
----------- -----------
4 160
