sql server
mustekgong
这个作者很懒,什么都没留下…
展开
-
sql 分组查询实例
select count(*),Gradeid form Student group by Gradeid order by count(*) desc 按照班级人数来分组查询 select gender,count(*) from student where datediff(yy,birthdate,getdate())>=20 group by gender order by cou原创 2013-05-10 10:56:36 · 370 阅读 · 0 评论 -
sql 模糊查询案例!
select * from student where ename like '%月%' or ename like '%定%'。原创 2013-05-10 10:37:33 · 446 阅读 · 0 评论 -
sql 查询关键字大团圆
select count(0) ,dinstinct , top(确定列) from 表(确定表) where 条件 (确定行) group by列(分组的列需要在选择列有该列) having 对组来做筛选条件(对组做筛选) order by 列(该列也要求选择列里要有的。)原创 2013-05-10 10:45:31 · 370 阅读 · 0 评论