Сортировка строк с помощью Order By (14 мин.)

Видео на Яндекс.Диске
Смотреть код

select
*
from
actor
order by
first_name;

select
*
from
actor
order by
first_name,
last_name;

select
*
from
actor
where
first_name like '%a%'
order by
         first_name,
         last_name;

select
*
from
actor
order by
first_name desc,
last_name;

select
*
from
actor
order by
first_name || last_name,
mod(actor_id, 10);

select
*
from
actor
order by
mod(actor_id, 10);

select
        first_name f,
        last_name l,
        actor_id i
from
        actor
order by
         f, l;

select
         last_name l,
         first_name f,
         actor_id i
from
         actor
order by
         1, 2;

select
*
from
address a
order by
address2 desc nulls last;

select
*
from
staff s
order by
picture nulls first;