有些会,有些不会.但还请教一下

[Shangliuxiaozhu]

数据库表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) 年龄最大的人的名字?

[chuifengde]

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

[chuifengde]

最后一条用with ties 没多大用，改一下:
select * from [user] a where age=(select max(age) from [user])

[Zoezs]

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)

[ks_reny]

[Quote=引用 1 楼 chuifengde 的回复:]
SQL codeselect * 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
[/Quote]
頂,這都是最基礎的.

[ai_li7758521]

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)

[ai_li7758521]

改

4.SELECT COUNT(1) num
    FROM [user]
  WHERE age>20