What are the differences between order by 1 and order by column name?
In the context of SQL the “SQL order by 1” is used to sort the query results based on the first column in the SELECT clause. On the other hand, the ORDER BY clause is used in arranging the retrieved data in both ascending and descending order. The basis used by the order is specified columns or the positional indices…
Answered Dec 14, 2023 · 868 Views Read answer →