sql练习及答案（SQL exercises and answers）.docVIP

sql练习及答案（SQL exercises and answers） -- (1) all the 20 sector employee information query. -- (2) query all types of CLERK staff, employees and departments. (case sensitive) Select empno, ename deptno, from EMP where upper (job) =CLERK -- (3) query (COMM) higher than the salary bonus (SAL) employee information. Select * from EMP where commsal -- (4) higher than 20% of the wages bonus query employee information. Select * from EMP where commsal*0.2 - (5) No. 10 department for the types of query types MANAGER and 20 departments in CLERK employee information. Select * from EMP where (job=MANAGERAND DEPTNO=10) OR (job=CLERKAND DEPTNO=20) - (6) MANAGER and CLERK are not all types of queries, and the wage is greater than or equal to 2000 employees with information. Select * from EMP where job not in (MANAGER,CLERK) And sal =2000 -- (7) query has different types of employee bonuses. Select distinct job from EMP where comm0 -- (8) query all the staff salary and bonus and. Select ename, NVL (SAL, 0) +nvl (comm, 0) from EMP -- (9) not less than 100 bonus bonuses or query employee information. Select * from EMP where comm is null or comm 100 -- (10) query of the month second day countdown employee information. Last_day Select * from EMP where hiredate=last_day (hiredate) -1 (11) the query length is greater than or equal to 10 years of employee information. Months_between Select * from EMP where TRUNC (months_between (sysdate, hiredate) /12) =10 Select * from EMP where ((sysdate-hiredate) /365) =10 (12) query employee information, required to display all employees name in capital letters lowercase the other way. Initcap Select initcap (ename) from EMP (13) query employees exactly 6 characters of employee information. Select * from EMP where length (ename) =6 (14) query letter S employees are not included in the name of the employee. Like or instr Select * from EMP where ename not like%S% Select * from EMP where instr (ename,S) =0 (15) query employee name second letter M employee i