Notes
Notes - notes.io |
2. Write a query to find the name (first_name, last_name) of all employees who works in the IT department.
3. Write a query to find the name (first_name, last_name) of the employees who have a manager and worked in a USA based department.
4. Write a query to find the name (first_name, last_name) of the employees who are managers.
5. Write a query to find the name (first_name, last_name), and salary of the employees whose salary is greater than the average salary.
6. Write a query to find the name (first_name, last_name), and salary of the employees whose salary is equal to the minimum salary for their job grade.
7. Write a query to find the name (first_name, last_name), and salary of the employees who earns more than the average salary and works in any of the IT departments.
8. Write a query to find the name (first_name, last_name), and salary of the employees who earns more than the earning of Mr. Bell.
9. Write a query to find the name (first_name, last_name), and salary of the employees who earn the same salary as the minimum salary for all departments.
10. Write a query to find the name (first_name, last_name), and salary of the employees whose salary is greater than the average salary of all departments.
11. Write a query to find the name (first_name, last_name) and salary of the employees who earn a salary that is higher than the salary of all the Shipping Clerk (JOB_ID = 'SH_CLERK'). Sort the results of the salary of the lowest to highest.
12. Write a query to find the name (first_name, last_name) of the employees who are not supervisors.
13. Write a query to display the employee ID, first name, last name, and department names of all employees.
14. Write a query to display the employee ID, first name, last name, salary of all employees whose salary is above average for their departments.
15. Write a query to fetch even numbered records from employees table.
16. Write a query to find the 5th maximum salary in the employees table.
17. Write a query to find the 4th minimum salary in the employees table.
18. Write a query to select last 10 records from a table.
19. Write a query to list the department ID and name of all the departments where no employee is working.
20. Write a query to get 3 maximum salaries.
21. Write a query to get 3 minimum salaries.
22. Write a query to get nth max salaries of employees.
|
|
Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 12 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team
