sql练习（四）

22、求2002年下半年入职的员工(考察知识点:单行函数)

select * from employees where HIRE_DATE between '2002-o6-o1' and '2002-12-31'

23、请用两种的方式查询所有名字长度为8的员工的员工编号,姓名

1、select * from employees where LENGTH(FIRST_NAME+LAST_NAME)=8

2、select * from employees where CHAR_LENGTH(FIRST_NAME+LAST_NAME)=8

24、打印下半年入职的员工信息(单行函数)

select * from employees where HIRE_DATE   between   '1000-o6-o1' and '3000-12-31'

25、打印本周的星期一时间信息

select * from employees where HIRE_DATE = date_sub(now(),interval dayofweek(now())-2 day)

26、打印入职时间超过10年的员工信息

select * from employees where  (date_sub(now(),interval dayofweek(now())-2 day)-HIRE_DATE)=10