Search⌘ K
AI Features
Home
Courses
SQL Interview Preparation

Answer: Sorting the Records

Explore how to sort records in SQL using the ORDER BY clause for ascending or descending order and the LIMIT clause to restrict results. Understand alternative methods such as UNION, WHERE conditions, and session variables to handle sorting challenges without native ranking functions.

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 ...