How does ORDER BY work with NULL

ORDER BY puts all NULLS first in ascending order

ORDER BY ignores NULLS in a random manner

ORDER BY puts all NULLS first in descending order

What is the appropriate placement of ORDER BY and GROUP BY in a query?

ORDER BY always goes after GROUP BY

ORDER BY always goes before GROUP BY

Use them in any placement you want

Quiz

jodie_pepworth 3 questions Updated 19 Feb 2016

Take the quiz

1Is the following true - ORDER BY can go below above or below the WHERE clause
1. ATrue
2. BFalse
2How does ORDER BY work with NULL
1. AORDER BY ignores NULLS in a random manner
2. BORDER BY puts all NULLS first in ascending order
3. CORDER BY puts all NULLS first in descending order
3What is the appropriate placement of ORDER BY and GROUP BY in a query?
1. AORDER BY always goes before GROUP BY
2. BORDER BY always goes after GROUP BY
3. CUse them in any placement you want

Description: Quiz on Aggregating data in SQL, created by jodie_pepworth on 16/09/2014.
Author: jodie_pepworth
Language: English
Views: 11
History: Created on 16 Sep 2014 · updated on 19 Feb 2016
Rating: No ratings yet
Rate this quiz
Rate this quiz