Order by With Union SQL

by

If I get your question correct, you want to order the indivual SELECTs seperately and you cannot use two ORDER BY clause per each statement instead, add an extra integer column to each SELECT as shown below:

SELECT *, 1 as orderBy from t1 
   UNION ALL
SELECT *, 2 as orderBy from t2
ORDER BY orderBy desc.

More Related Contents:

  1. how to get result form mysql query in specific ids [closed]
  2. How To have Dynamic SQL in MySQL Stored Procedure
  3. Can MySQL split a column?
  4. mysql Foreign key constraint is incorrectly formed error
  5. Unknown Column In Where Clause
  6. Left Join not returning all rows
  7. MySQL match() against() – order by relevance and column?
  8. Maximum length for MySQL type text
  9. How to count words in MySQL / regular expression replacer?
  10. gem install: Failed to build gem native extension (can’t find header files)
  11. Entity-Attribute-Value Table Design
  12. Filter by COUNT(*)?
  13. MySQL concatenation operator
  14. SQL Group By with an Order By
  15. How to Convert UTC Date To Local time Zone in MySql Select Query
  16. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  17. MySql – Way to update portion of a string?
  18. Using reserved words in column names
  19. MySQL INNER JOIN select only one row from second table
  20. How to select only date from a DATETIME field in MySQL?
  21. UPDATE all records with a random number from a range
  22. mysql sorting of version numbers
  23. Get Insert Statement for existing row in MySQL
  24. Can’t access mysql from command line on a Mac
  25. Defining Composite Key with Auto Increment in MySQL
  26. mysql Failed to read auto-increment value from storage engine
  27. Alter table if exists or create if doesn’t
  28. How to use Table output from stored MYSQL Procedure
  29. How can I stop a MySQL query if it takes too long?
  30. “General error: 1005 Can’t create table” Using Laravel Schema Build and Foreign Keys

Leave a Comment