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 perguntas Atualizado em 19 fev 2016

Fazer o quiz

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

Descrição: Quiz sobre Aggregating data in SQL, criado por jodie_pepworth em 16-09-2014.
Autor: jodie_pepworth
Idioma: English
Visualizações: 11
Histórico: Criado em 16 set 2014 · atualizado em 19 fev 2016
Avaliação: Ainda sem avaliações
Avalie este quiz
Avalie este quiz