SQL ORACLE

Clauza ORDER BY


×

Exercitii clauza ORDER BY

Ordonare studenti

Extrageti toate datele din tabela Studenti ordonand crescator dupa coloana Varsta.

Select * from studenti order by varsta asc;

Ordonare studenti

Extrageti toate datele din tabela Studenti ordonand descrescator dupa coloana id_profesor.

Select * from studenti order by id_profesor desc;

Ordonare studenti

Extrageti toate datele din tabela Studenti ordonand descrescator dupa coloana id_profesor si crescator dupa varsta student.

Select * from studenti order by id_profesor desc,varsta asc;