Combining UNION and LIMIT operations in MySQL query

by

Quoting the docs,

To apply ORDER BY or LIMIT to an
individual SELECT, place the clause
inside the parentheses that enclose
the SELECT:

(SELECT a FROM t1 WHERE a=10 AND B=1 ORDER BY a LIMIT 10)
UNION
(SELECT a FROM t2 WHERE a=11 AND B=2 ORDER BY a LIMIT 10);

More Related Contents:

  1. MySQL – How to unpivot columns to rows?
  2. SQL Performance UNION vs OR
  3. Using union and order by clause in mysql
  4. UNION query with codeigniter’s active record pattern
  5. How to set a maximum execution time for a mysql query?
  6. Recreating a query using INNER JOIN? [duplicate]
  7. Create a Cumulative Sum Column in MySQL
  8. Equivalent of explode() to work with strings in MySQL
  9. MySQL Trigger after update only if row has changed
  10. MySQL “WITH” clause
  11. mysql select dynamic row values as column names, another column as value
  12. Illegal mix of collations MySQL Error
  13. SQL query: Delete all records from the table except latest N?
  14. SQL order string as number
  15. Find most frequent value in SQL column
  16. How to convert number of week into date?
  17. update multiple rows using limit in mysql?
  18. Mysql 1050 Error “Table already exists” when in fact, it does not
  19. How to get the latest record in each group using GROUP BY? [duplicate]
  20. When to use SELECT … FOR UPDATE?
  21. Setting column values as column names in the SQL query result
  22. How do I UPDATE a row in a table or INSERT it if it doesn’t exist?
  23. SQL unique varchar case sensitivity question
  24. How do I count columns of a table
  25. Laravel join with 3 Tables
  26. How to regex in a MySQL query
  27. MySQL 5.6 – DENSE_RANK like functionality without Order By
  28. Syntax error on MERGE statement
  29. INSERT INTO Table from multiple tables
  30. Mysql How do you create a clustered index?

Leave a Comment