How to order by with union in SQL?

Just write

Select id,name,age
From Student
Where age < 15
Union
Select id,name,age
From Student
Where Name like "%a%"
Order by name

the order by is applied to the complete resultset

Related Posts:

  1. Using union and order by clause in mysql
  2. What is the difference between UNION and UNION ALL?
  3. What is the difference between JOIN and UNION?
  4. Algebra Relational sql GROUP BY SORT BY ORDER BY
  5. The used SELECT statements have a different number of columns
  6. How to order by column A and then by column B?
  7. Selecting COUNT(*) with DISTINCT
  8. ORA-00904: invalid identifier
  9. Unknown column in ‘field list’ error on MySQL Update query
  10. When should I use CROSS APPLY over INNER JOIN?
  11. Insert Data Into Temp Table with Query
  12. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  13. SQL SELECT WHERE field contains words
  14. Using group by on multiple columns
  15. Efficiently convert rows to columns in sql server
  16. Nested select statement in SQL Server
  17. What’s the difference between VARCHAR and CHAR?
  18. How to split the name string in mysql?
  19. How do you trouble shoot a “Data type mismatch in criteria expression” error in MS Access 2010?
  20. Sql Server equivalent of a COUNTIF aggregate function
  21. Column name or number of supplied values does not match table definition
  22. Simple PHP Pagination script
  23. CREATE VIEW must be the only statement in the batch
  24. SQL Server FOR EACH Loop
  25. ORA-12560: TNS:protocol adaptor error
  26. How can I select the first day of a month in SQL?
  27. Warning: Null value is eliminated by an aggregate or other SET operation in Aqua Data Studio
  28. SQL – HAVING vs. WHERE
  29. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  30. Oracle Apex column link from LOV values
  31. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  32. MySQL combine two columns into one column
  33. How to SUM two fields within an SQL query
  34. DateTime2 vs DateTime in SQL Server
  35. ORA-01861: literal does not match format string
  36. Difference between numeric, float and decimal in SQL Server
  37. SQL Server Insert if not exists
  38. SQL Server: Invalid Column Name
  39. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  40. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  41. How do I query for all dates greater than a certain date in SQL Server?
  42. Count(*) vs Count(1) – SQL Server
  43. Remove duplicate rows in MySQL
  44. Cast from VARCHAR to INT – MySQL
  45. Conversion failed when converting the varchar value ‘simple, ‘ to data type int
  46. postgresql: error duplicate key value violates unique constraint
  47. Is there a workaround for ORA-01795: maximum number of expressions in a list is 1000 error?
  48. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  49. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  50. Insert into a MySQL table or update if exists
  51. How to round down to nearest integer in MySQL?
  52. Convert timestamp to date in Oracle SQL
  53. How do I reset a sequence in Oracle?
  54. MySQL error: key specification without a key length
  55. SQL: Two select statements in one query
  56. How to query MongoDB with “like”
  57. Check if MySQL table exists without using “select from” syntax?
  58. mysql update column with value from another table
  59. what is the difference between triggers, assertions and checks (in database)
  60. Replacing NULL with 0 in a SQL server query
  61. SQL Server dynamic PIVOT query?
  62. How to delete from multiple tables in MySQL?
  63. How to copy a row and insert in same table with a autoincrement field in MySQL?
  64. Error converting data type varchar
  65. I want to use CASE statement to update some records in sql server 2005
  66. What does Include() do in LINQ?
  67. SQL Server “cannot perform an aggregate function on an expression containing an aggregate or a subquery”, but Sybase can
  68. Get everything after and before certain character in SQL Server
  69. Cannot create an instance of OLE DB provider Microsoft.Jet.OLEDB.4.0 for linked server null
  70. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  71. ROW_NUMBER() in MySQ
  72. LEFT function in Oracle
  73. What are database constraints?
  74. Postgresql column reference “id” is ambiguous
  75. Inner Joining three tables
  76. How do I view the Explain Plan in Oracle Sql developer?
  77. ORA-01779: cannot modify a column which maps to a non key-preserved table
  78. SUM OVER PARTITION BY
  79. SQLite string contains other string query
  80. Varchar invalid for Sum operator
  81. SQL: How to properly check if a record exists
  82. Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
  83. Sorting search results by taxonomy terms
  84. How to properly sanitize strings without $wpdb->prepare?
  85. WordPress SQL LIKE request doesn’t work for fields with special symbols
  86. posts_where Fails with More than One Custom Field in Query
  87. Restose content from revisions – sql query
  88. Better way to migrate to server?
  89. Inner Join user tables to select users with roles
  90. $wpdb->prepare with LIKE returning blank array instead of rows
  91. Removing posts by sql
  92. WooCommerce database query : Get product category image path+name from thumbnail_id [closed]
  93. WordPress can I manually add columns in users table and display it in the default manage user plugin and registration form? [closed]
  94. Help me SELECT thumbnail from SQL and use
  95. Why is my insert row only inserting the final row from the loop into the database rather than just inserting one
  96. Search results sort order failing: set by date only
  97. Creating a “forum” – showing last post or last commented post
  98. Replace Unwanted Space in Post Content URL
  99. SQL to transform all email addresses in my DB in lowercase [closed]
  100. How to write inner join using posts_clauses?

Leave a Comment