You are viewing a single comment's thread. Return to all comments →
If you have a rownum (i.e. Oracle) you can't use it in one query with order by, the rownum is assigned before order by is applied. You can wrap it in another query and use rownum there, or use row_number, or switch db.