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
No comments:
Post a Comment