...
will sort the dataset by the field f1 in ascending order and by f2 in descending order.
f1 ASC, f2 DESC LIMIT 2
will sort the dataset by the field f1 in ascending order and by f2 in descending order, and will limit the number of records returned to 2.
LIMIT 5
will limit the number of records returned to 5.
...