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

Test

jodie_pepworth 3 preguntas Actualizado el 19 feb 2016

Hacer el test

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

Descripción: Test sobre Aggregating data in SQL, creado por jodie_pepworth el 16/09/2014.
Autor: jodie_pepworth
Idioma: English
Visitas: 11
Historial: Creado el 16 sep 2014 · actualizado el 19 feb 2016
Valoración: Aún sin valoraciones
Valora este test
Valora este test