数据库pubs中查询.doc

1.1 查询 jobs表中的所有信息。 select * from jobs 1.2 查询雇员号和雇员姓名 select emp_id,fname+-+lname as Name from employee 1.3 查询 omployee中雇员工作年限的信息 select emp_id,fname+-+lname as Name,Year(getdate())-Year(hire_date) as worke time from employee order by worke time 2.1 查询姓名首字母为f的雇员信息 select * from employee where fname like f% 2.2 查询工种代号为11的雇员信息 select * from employee where job_id=11 2.3 查询雇佣年限超过5年的雇员信息 select emp_id,fname+-+lname as Name, Year(getdate())-Year(hire_date) as worketime from employee where (Year(getdate())-Year(hire_date)) 5 order by worketime 2.4 查询工种代号在5-8之间的雇员信息。 select * from employee where cast(job_id as integer)=5 and cast(job_id as integer)=8 2.5查询名字为Maria的雇员信息 select * from employee where fname=Maria 2.6 select * from employee where fname like %sh% or lname like %sh% 查询姓名中包含sh的所有雇员的信息 3.1 select * from sales where ord_date 1993-1-1 查询订单日期早于1993-1-1前订货信息