文档介绍：1:
select distinct name from table where name not in (select distinct name from table where fenshu<=80)
select name from table where name not in (select distinct name from table where fenshu<=80)
group by name
2:
delete tablename where [自动编号] not in(select min([自动编号]) from tablename group by [学号],[姓名],[课程编号],[课程名称],[分数])
3:
SELECT testtable2.* , ISNULL(department,'黑人')
FROM testtable1 right join testtable2 on =
4:
ame,case when avg(score)>=80 then '优秀' when avg(score)>=60 then '及格' else '不及格' end
from SC group ame
5:
select rq, sum(case when shengfu='胜' then 1 else 0 end)'胜',sum(case when shengfu='负' then 1 else 0 end)'负' from #tmp group by rq
select ,, from
(select rq,胜=count(*) from #tmp where shengfu='胜'group by rq)N inner join
(select rq,负=count(*) from #tmp where shengfu='负'group by rq)M on =
6:
select * from
(
select *,case when [page].[url] like '%baidu%' then 100
when [page].[title] like '%baidu%' then 50
when [page].[body] like '%baidu%' then 10
else 0 end as mark from [page]
) A order by mark
select a.[id], from
(
select [page].[id],100 as mark from [page] where [page].[url] like '%baid