# OK : simple orderingselect * from staff order by last_name, first_name\p\gselect * from staff order by last_name desc\p\gselect * from staff order by last_name desc, first_name\p\gselect * from pay order by pay_date\p\gselect * from pay order by pay_time desc\p\gselect * from pay order by pay_amount asc, pay_date\p\g# OK : distinct testingselect distinct staff_id from pay\p\gselect distinct staff_id,pay_amount from pay order by staff_id desc\p\g# OK : ordering with sysvars in resultselect _rowid, staff_id, uname from users order by uname\p\g# OK : ordering with sysvars in result and orderselect _rowid, staff_id, uname from users order by _rowid desc\p\g