w3resource
SQL exercises

SQL exercises on employee Database: Find the salaries of all employees

SQL employee Database: Exercise-2 with Solution

[An editor is available at the bottom of the page to write and execute the scripts.]

2. Write a query in SQL to find the salaries of all employees.

Sample table: employees


Pictorial Presentation:

SQL exercises on employee Database: Find the salaries of all employees

Sample Solution:

SELECT salary
FROM employees;

Sample Output:

 salary
---------
 6000.00
 2750.00
 2550.00
 2957.00
 3100.00
 3100.00
  900.00
 1700.00
 1350.00
 1350.00
 1600.00
 1200.00
 1050.00
 1400.00
(14 rows)

Practice Online


Sample Database: employee

employee database structure

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a query in SQL to display all the information of the employees.
Next: Write a query in SQL to display the unique designations for the employees.

What is the difficulty level of this exercise?