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 Fragen Aktualisiert am 19 Feb 2016

Quiz starten

1Is the following true - ORDER BY can go below above or below the WHERE clause
1. ARichtig
2. BFalsch
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

Beschreibung: Quiz am Aggregating data in SQL, erstellt von jodie_pepworth am 16/09/2014.
Autor: jodie_pepworth
Sprache: English
Aufrufe: 11
Verlauf: Erstellt am 16 Sep 2014 · aktualisiert am 19 Feb 2016
Bewertung: Noch keine Bewertungen
Bewerte dieses Quiz
Bewerte dieses Quiz