Search⌘ K
Home
Courses
SQL Interview Preparation

Answer: Sorting the Records

Explore sorting SQL records effectively by using ORDER BY with ASC or DESC, alongside the LIMIT clause to restrict output. Understand alternate solutions including UNION, WHERE, and session variables to solve common SQL interview questions on sorting employee salaries.

We'll cover the following...

Solution

The solution is given below:

MySQL
/* The query to find top 3 highly paid employees */
SELECT   EmpName, Salary
FROM     Employees 
ORDER BY Salary DESC 
LIMIT    3;

Explanation

The explanation of the solution code is given below:

  • Line 2: The SELECT query selects EmpName and Salary columns.

  • Line 3: The FROM clause specifies the table name as Employees.

  • Line 4: The ORDER BY clause sorts the Salary column in descending order.

  • Line 5: We use the LIMIT clause here. This clause limits the records to the specified value.

Recall of relevant concepts

We have covered the following concepts in this question:

  • Selective columns

  • Sorting the results

  • Limiting records

Let’s discuss the concepts used in the solution:

  • We ...