34,587
社区成员
发帖
与我相关
我的任务
分享
create table test
(
id int null ,
name varchar(10)
)
insert test
select 1,'1'union select
3,'3' union select
2,'sad' union select
null,'sad'
select name from test where id>all(select id from test where name='sad')
/*
name
----------
*/
select name from test where id>(select MAX(id)from test where name='sad')
/*
name
----------
DECLARE @TB TABLE(ID INT,NAME VARCHAR(10))
INSERT @TB
SELECT 1 ,'A' UNION ALL
SELECT 1 ,'B' UNION ALL
SELECT 2 ,'A' UNION ALL
SELECT 3 ,'C'
SELECT name FROM @TB WHERE ID > ALL(SELECT ID FROM @TB WHERE NAME = 'A')
SELECT name FROM @TB WHERE ID > (SELECT MAX(ID) FROM @TB WHERE NAME = 'A')
/*
(所影响的行数为 4 行)
name
----------
C
(所影响的行数为 1 行)
name
----------
C
(所影响的行数为 1 行)