select * from [user] where sex=0 and age=20 order by name desc select age=age+1 from [user] where sex=1 delete from [user] where id %2 =1 select count(1) from [user] where age>20 select top 1 with ties name from [user] order by age desc
最后一条用with ties 没多大用,改一下: select * from [user] a where age=(select max(age) from [user])
1.select * from user where sex=0 and age=20 order by name desc 2.update user set age=age+1 where sex=1 3.delete from user where ID/2<>0 4.select count(*) from user where age>20 5.select name from user a where not exists(select top 1 0 from user where a.age>age)
1.SELECT name FROM [user] WHERE sex=0 and age=20 ORDER BY name DESC2.UPDATE [user] SET age=age+1 WHERE sex=13.--奇数据? DELETE FROM [user]4.SELECT COUNT(1) num FROM [user] WHERE age=20 5.SELECT A.name FROM [user] A WHERE NOT EXISTS (SELECT 1 FROM [user] B WHERE B.age>A.age)
select age=age+1 from [user] where sex=1
delete from [user] where id %2 =1
select count(1) from [user] where age>20
select top 1 with ties name from [user] order by age desc
select * from [user] a where age=(select max(age) from [user])
1.select * from user where sex=0 and age=20 order by name desc
2.update user set age=age+1 where sex=1
3.delete from user where ID/2<>0
4.select count(*) from user where age>20
5.select name from user a where not exists(select top 1 0 from user where a.age>age)
FROM [user]
WHERE sex=0 and age=20
ORDER BY name DESC2.UPDATE [user]
SET age=age+1
WHERE sex=13.--奇数据?
DELETE FROM [user]4.SELECT COUNT(1) num
FROM [user]
WHERE age=20 5.SELECT A.name
FROM [user] A
WHERE NOT EXISTS (SELECT 1 FROM [user] B WHERE B.age>A.age)
4.SELECT COUNT(1) num
FROM [user]
WHERE age>20