《17.3 t-sql基本查询》由会员分享,可在线阅读,更多相关《17.3 t-sql基本查询(2页珍藏版)》请在金锄头文库上搜索。
1、1 SELECT name,home_addrfrom student2 select professionfrom teacher3 SELECT namefrom studentwhere name like %刘% or name like %张%4 select name,年龄=year(getdate()-year(birthday)from student5 select name,home_addrfrom student6 select student_id,course_id,gradefrom resultwhere grade857 select student_id,c
2、ourse_id,gradefrom resultwhere course_id in(c01,c02) and grade=858 select name,teacher_id,profession,salaryfrom teacherwhere salary between1000 and 15009 select name,年工资 = salary*12from teacher10 select name,teacher_idfrom teacherwhere name like _一% 11 select student_id as 学号,name as 姓名,home_addr as
3、 家庭住址from student12 select name,年龄=year(getdate()-year(birthday)from studentwhere year(getdate()-year(birthday) not between 18 and 2013 select teacher_id,name,telephonefrom teacherwhere telephone like_234%14 select student_id,course_id,gradefrom resultwhere grade is null15 select course_id,max(grade
4、),min(grade), max(grade)-min(grade) 分差from resultwhere course_id=( select course_id from course where name=程序设计)16 select student_id,course_id,creditfrom result where credit is null17 select student_id,sum(grade)from resultgroup by gradehaving sum(grade)35018 select student_id,course_id,gradefrom resultwhere course_id in(c02,c03,c04)order by student_id ,grade desc19 select name,home_addr,sexfrom studentwhere home_addr like 南京% and sex =男20 select *from studentwhere YEAR(birthday)1980