[go: up one dir, main page]
Scribd
Upload
16 views1 page

Sql-I - A

Uploaded by

sreeni.thummana
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
16 views1 page

Sql-I - A

Uploaded by

sreeni.thummana
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

1.

List out the employee id, last name in ascending order based on the employee
id.
2. List out the employee id, name in descending order based on salary column
3. list out the employee details according to their last_name in ascending order
and salaries in descending order
4. list out the employee details according to their last_name in ascending order
and then on department_id in descending order.
5. How many employees who are working in different departments wise in the
organization

51. How many employees who are working in different departments and display with
department name.
52. How many employees who are working in sales department.
53. Which is the department having greater than or equal to 5 employees and
display the department names in ascending order.
54. How many jobs in the organization with designations.
55. How many employees working in �New York�.
56. Display employee details with salary grades.
57. List out the no. of employees on grade wise.
58. Display the employ salary grades and no. of employees between 2000 to 5000
range of salary.
59. Display the employee details with their manager names.

You might also like