applying a seconday sorting on sorted data

[davidklonski]

Hello

Does anyone know how I can perform a secondary sort on data which is already sorted.

For example, if I run the following query:
SELECT * FROM table ORDER BY AAA;

I would like the rows which have a matching AAA attribute to be sorting according to some other attribute (BBB for example)

thanks in

[zhabala]

SELECT * FROM table ORDER BY AAA, BBB;

each sorting parameter can be followed by ASC or DESC for ascending or descending sort.