Which statement about SQL is true?

Question

a. Null values are displayed last in the ascending sequences.

b. Data values are displayed in descending order by default.

c. You cannot specify a column alias in an ORDER BY clause.

d. You cannot sort query results by a column that is not included in the SELECT list.

e. The results are sorted by the first column in the SELECT list, if the ORDER BY clause is not provided.

Answer 1

The correct answer is, option (a): Null values are displayed last in the ascending sequences. And rest all are incorrect answers pertaining to SQL. Wish to be an expert in SQL? Check out the SQL course from Intellipaat, to help you get trained and skilled in SQL through instructor-led training and guided projects to help you acquire the required practical skills. Also, check out our YouTube video on SQL Tutorial For Beginners.