SQL Interview Preparation/

...

/

Answer: Sorting the Records

Answer: Sorting the Records

Find a detailed explanation of how to get the results of a query in sorted order.

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