22,206
社区成员
发帖
与我相关
我的任务
分享
if object_id('tb') IS NOT NULL DROP TABLE tb
CREATE TABLE tb(a VARCHAR,b VARCHAR,c VARCHAR)
GO
INSERT INTO tb SELECT '1',2,'2'
UNION ALL SELECT '1','2','3'
UNION ALL SELECT '1','2','4'
UNION ALL SELECT '2','2','4'
UNION ALL SELECT '3','2','4'
select a.* from tb a where 1 > (select count(*) from tb where c > a.c )
--找出c为最大的所有行
if object_id('tb') IS NOT NULL DROP TABLE tb
CREATE TABLE tb(a VARCHAR,b VARCHAR,c VARCHAR)
GO
INSERT INTO tb SELECT '1',2,'2'
UNION ALL SELECT '1','2','3'
UNION ALL SELECT '1','2','4'
UNION ALL SELECT '2','2','4'
UNION ALL SELECT '3','2','4'
select a.* ,(select count(*) from tb where c > a.c ) from tb a
(所影响的行数为 5 行)
a b c
---- ---- ---- -----------
1 2 2 4
1 2 3 3
1 2 4 0
2 2 4 0
3 2 4 0
(所影响的行数为 5 行)