如何查询出价格为第三大
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