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

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;