SQL Interview Questions part 2
You can see Part 1 here.
16) Display the names of all tables from current user.
17) Display the name of the current user.
18) Display the names of employees working in depart number 10 or 20 or 40 or employees working as CLERKS,SALESMAN or ANALYST.
19) Display the names of employees whose name starts with alaphabet S.
20) Display the Employee names for employees whose name ends with alaphabet S.
21) Display the names of employees whose names have second alphabet A in their names.
22) select the names of the employee whose names is exactly five characters in length.
23) Display the names of the employee who are not working as MANAGERS.
24) Display the names of the employee who are not working as SALESMAN OR CLERK OR ANALYST.
25) Display all rows from emp table.The system should wait after every screen full of information.
26) Display the total number of employee working in the company.
27) Display the total salary beiging paid to all employees.
28) Display the maximum salary from emp table.
29) Display the minimum salary from emp table.
30) Display the average salary from emp table.