ORDONARI IN TABELE

ORDONARI IN TABELE

Naturala

Ordine Fizica - Sortare

Modificata

Logica - Indexare

SORTAREA

Chei de sortare - cheie primara, chei secundare

Domeniu implicit - ALL
Exemplul1: SORT TO NUME ON NP

USE NUME

BROW

Exemplul2: SORT TO AN2 ON SERIA,GRUPA,NP

USE AN2

BROW

Clauza Fields

Sablon (masca) - * ?

Exemplu: SERIA - mastile S* si S?

FIELDS LIKE <sablon>

FIELDS EXCEPT <sablon>

Exemplul 3:

SORT TO STUD_NP ON NP FIELDS LIKE N*

USE STUD_NP

BROW

Exemplul 4:

USE STUDENT

SORT TO STUD_MD ON MEDIA FIELDS EXCEPT NOTA?

USE STUD_MD

BROW

Exemplul 5:

USE STUDENT

SORT TO STUD_N1 ON NOTA1 FIELDS LIKE N* EXCEPT N?

USE STUD_N1

BROW

Comutatorii /A, /D, /C

Exemplul 6:

USE STUDENT

SORT TO STUD_MNP ON MEDIA/D, NP/A/C;

FIELDS NP,MEDIA,SERIA,GRUPA

USE STUD_MNP

BROW

Clauzele ASCENDING | DESCENDING

EXEMPLUL 7:

USE STUDENT

SORT TO STUD_N2N3NP ON NOTA2,NOTA3,NP/A;

DESCENDING FIELDS NOTA2,NOTA3,NP

USE STUD_N2N3NP

BROW