SQL Server SQL高级查询.docxVIP

SQL Server SQL高级查询高级查询在数据库中用得是最频繁的，也是应用最广泛的。? 基本常用查询--selectselect * from student;?--all 查询所有select all sex from student;?--distinct 过滤重复select distinct sex from student;?--count 统计select count(*) from student;select count(sex) from student;select count(distinct sex) from student;?--top 取前N条记录select