150 SQL Queries

150 SQL Queries, www.askhareesh.com
1.Display the dept information from department table

2.Display the details of all employees

3.Display the name and job for all employees

4.Display name and salary for all employees

5.Display employee number and total salary for each employee

6.Display employee name and annual salary for all employees

7.Display the names of all employees who are working in department number 10

8.Display the names of all employees working as clerks and drawing a salary more than 3000

9.Display employee number and names for employees who earn commission

10.Display names of employees who do not earn any commission

11.Display the names of employees who are working as clerk , salesman or analyst and drawing a salary more than 3000

12.Display the names of employees who are working in the company for the past 5 years

13.Display the list of employees who have joined the company before 30th june 90 or after 31st dec 90

14.Display current date

15.Display the list of users in your database (using log table)

16.Display the names of all tables from the current user

17.Display the name of the current user

18.Display the names of employees working in department number 10 or 20 or 40 or employees working as clerks , salesman or analyst

19.Display the names of employees whose name starts with alphabet S

20.Display employee name from employees whose name ends with alphabet S 




*/

No comments:

Post a Comment