SQL Server Course for Beginners with 100+ examples - ORDER BY Keyword in SQL

The video tutorial explains how to use the 'order by' keyword in SQL Server to sort records in ascending or descending order. It covers the default behavior of ordering in ascending order and demonstrates how to sort records by salary. Additionally, it shows how to handle multiple columns, such as city and salary, to resolve ordering issues with repeated values.

What is the default sorting order when using the 'order by' keyword in SQL Server?

• Descending order

• Alphabetical order

• Random order

• Ascending order

Which SQL command is used to display all records from a table?

• LIST ALL FROM table_name

• DISPLAY * FROM table_name

• SHOW ALL FROM table_name

• SELECT * FROM table_name

How can you sort records in descending order using the 'order by' keyword?

• Use the keyword DOWN

• Use the keyword REVERSE

• Use the keyword ASC

• Use the keyword DESC

When sorting by multiple columns, which column is used first?

• The column specified first in the 'order by' clause

• The column with the lowest values

• The column with the highest values

• The column with the most unique values

What happens if there are repeated values in the first column when sorting by multiple columns?

• The records are left unsorted

• The records are sorted by the second column

• The records are duplicated

• The records are sorted in reverse order