-
本版专家分：0结帖率 62.5% -
数据库表user pk ID int
Name (char) Age(int) Sex(bit)
(1) sex=0,age=20的name降序 ?
(2) 当sex=1时，age+1?
(3) 删除所有奇数据?
(4) 统计age>20的个数?
(5) 年龄最大的人的名字?![]()
-
本版专家分：58023 -
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
-
本版专家分：58023
-
最后一条用with ties 没多大用，改一下:
select * from [user] a where age=(select max(age) from [user])
-
本版专家分：11982 -
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)
-
本版专家分：10609
-
頂,這都是最基礎的.
-
本版专家分：22938
-
- 红花 2009年6月 MS-SQL Server大版内专家分月排行榜第一
-
-
1.SELECT name
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]
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)![]()
-
本版专家分：22938
-
- 红花 2009年6月 MS-SQL Server大版内专家分月排行榜第一
-
-
改
4.SELECT COUNT(1) num
FROM [user]
WHERE age>20