skyxuyan的专栏

SqlConnection con = new SqlConnection("server=localhost;database=bookmanage;uid=sa;pwd=1234"); con.Open(); string sql = "SELECT ID,CONVERT(VARCHAR(10),nowdate ,110) as 时间 FROM Insert

select avg(cast (score as int)) from{ select top 5 score from table order by score desc}p

select * from (select top 80percent * from table order by id)texcept(select top 20percent * from table order by id)在此基础上  查询最大值 select MAX(data1) as maxnum from(select * from (select t

创建表：create table student ( studentID int primary key identity(1,1), -------------自增长，标识为1 studentname varchar(50),)create table borrowreader(borrowID int primary key identity(1,

表t_stu；其中三个字段:name,gender,grade；要求用一条sql语句查出男生前5名和女生前五名  select * from t_stu a where 5>(select count(*) FROM t_stu where gender=a.gender AND grade>a.grade) order by a.grade desc 对这个sql的理解是 对于每