Hi all,

If you have to set the ORDER BY condition for one column only, there is another solution:

select *
from MyTable
where field = (select max(field)
from MyTable)


This is standard SQL, and if field is primary key, or there's an index on field, probably this is the fastest query that solves your problem.