数据结构如下
ID 值
1 1
2 4
3 5
4 6
5 7
6 8
查询出前三行数据的最大值，也就是5，SQL语句该怎么写？
------解决方案--------------------
- SQL code
--> 测试数据：[test]if object_id('[test]') is not null drop table [test]create table [test]([ID] int,[值] int)insert [test]select 1,1 union allselect 2,4 union allselect 3,5 union allselect 4,6 union allselect 5,7 union allselect 6,8select top 1 * from(select top 3 * from test order by GETDATE())torder by [值] desc/*ID 值3 5*/
------解决方案--------------------
- SQL code
select max([值]) from ( select top 3 * from yourtable order by id asc) a