摘要：
Group by Fage Having Count(*)>1限制结果集行数Select top 3 * from T_Employee order by FSalary desc检索按照工资从高到低排序检索从第六名开始一共三个人的信息select top 3 * from T_Employeewhere FNumber not in (select top 5 FNumber from T_Employee order by FSalary desc)order by FSalary descsql server2005后增加了Row_Number函数简化实现，用Row_Number函 阅读全文
摘要：
一、SQL基础知识1、DDL（数据定义语言）1）创建数据表--创建数据表createtableTest(Idintnotnull,Agechar(20))；--创建数据表createtableT_Person1(Idintnotnull,Name nvarchar(50),Ageintnull)；--创建表，添加外键CreatetableT_Students(StudentNochar(4),CourseNochar(4),Scoreint,Primarykey(StudentNo),Foreignkey(CourseNo)ReferencesT_Course(CourseNo));2)修改表 阅读全文