Sql Order Descending Date. Code language SQL (Structured Query Language) (sql) In this case the ORDER BY clause First sort the result set by the values in the column1 in ascending order Then sort the sorted result set by the values in the column2 in descending orderNote that the order of values in the column1 will not change in this step only the order of values in the column2 changes.
SQL INTERSECT with ORDER BY example To sort the result set returned by the INTERSECT operator you place the ORDER BY clause at the end of all statements For example the following statement applies the INTERSECT operator to the A and B tables and sorts the combined result set by the id column in descending order SELECT id FROM a INTERSECT SELECT id FROM b.
Understanding SQL INTERSECT Operator
Overview Of The Sql Order By Clause
MySQL ORDER BY MySQL Tutorial