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

Last update on May 30 2022 07:28:26 (UTC/GMT +8 hours)

SQL employee Database: Exercise-2 with Solution

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

2. From the following table, write a SQL query to find the salaries of all employees. Return salary.

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)

Relational Algebra Expression:

Relational Algebra Tree:

Practice Online

Sample Database: employee

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

Previous: From the following table return complete information about the employees.
Next: From the following table, write a SQL query to find the unique designations of the employees. Return job name.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.

SQL: Tips of the Day

SQL Server SELECT into existing table.

INSERT INTO dbo.TABLETWO
SELECT col1, col2
  FROM dbo.TABLEONE
 WHERE col3 LIKE @search_key

This assumes there's only two columns in dbo.TABLETWO - you need to specify the columns otherwise:

INSERT INTO dbo.TABLETWO
  (col1, col2)
SELECT col1, col2
  FROM dbo.TABLEONE
 WHERE col3 LIKE @search_key

Database: SQL Server

Ref: https://bit.ly/3y6tpA3