34,590
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#a') is null
drop table #a
Go
Create table #a([aa] int,[bb] int,[cc] int)
Insert #a
select 1,15,22 union all
select 2,55,33 union all
select 5,13,35
Go
--测试数据结束
SELECT aa,bb,cc
FROM ( SELECT * ,
ROW_NUMBER() OVER ( ORDER BY bb DESC ) rn
FROM #a
) t
WHERE t.rn = 1
USE tempdb
GO
IF OBJECT_ID('t') IS NOT NULL DROP TABLE t
GO
CREATE TABLE t(aa int,bb int,cc int)
INSERT INTO t
SELECT 1,15,22
UNION ALL SELECT 2,55,33
UNION ALL SELECT 5,13,35
--两种都可以
--1.
SELECT * FROM t AS a WHERE NOT EXISTS(
SELECT 1 FROM t AS b WHERE b.bb>a.bb
)
--2.
SELECT * FROM t WHERE bb=(SELECT MAX(bb) FROM t)
/*
aa bb cc
2 55 33
*/