Search
Search

MySql Query Limit based on Sub Query Value

debugcn Published at Dev
13
DonOfDen

I am looking for a solution to use sub query in limit value.

Ex:

SELECT *
FROM `user`
WHERE usertype='6' LIMIT
  (SELECT count(*) FROM allowed WHERE usertype='6')

Is there any other way to use a sub Query in LIMIT. I tried the above Query but Its not working.

davek

This is not possible with MySql; you have to use a stored procedure/prepared statement as workaround.

Lots of people have requested this:

http://bugs.mysql.com/bug.php?id=8094

but as you see from the bug listing, this is still open.

EDIT: actually, it seems to have been added in version 5.5.6:

http://bugs.mysql.com/bug.php?id=11918

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

MYSQL INSERT query based on SELECT query with LIMIT restrictions

From Dev

Performance considerations for SUB QUERY, LIMIT and ORDER BY when using MySQL

From Dev

MySQL NOT in Sub Query

From Dev

MySQL Sub Query difficulty

From Dev

mysql query based on value of previous row

From Dev

mysql select query php based on column value

From Dev

mysql query based on value of previous row

From Dev

Make a MySQL query fail by value based decision

From Dev

Print MySQL Output Based on Query String Value

From Dev

MySQL Query to find row duplicates based on condition with limit

From Dev

Overriding Data based on sub query

From Dev

Optimize MySQL query with dependent sub-query

From Dev

MySQL Query with Sub-Query optimisation

From Dev

Sub query to fetch the highest value

From Dev

Sub query to search for value in a column

From Dev

Replacing sub query with join in mysql

From Dev

MySQL sub query on the same table

From Dev

mysql sub query for find grade

From Dev

how to make mysql sub query

From Dev

MYSQL Sub Query with two columns

From Dev

like is not working in mySql sub query

From Dev

MySQL Sub Sub Query seems to loop

From Dev

Optimizing a sub-sub-query in MySQL

From Dev

3 MYSQL query using 1 query and limit

From Dev

MySQL Query add limit in SubQuery

From Dev

Limit characters in mysql query column

From Dev

Mysql complex query, group by with limit

From Dev

MYSQL query and LIMIT to one row

From Dev

Limit characters in mysql query column

Related Related

  1. 1

    MYSQL INSERT query based on SELECT query with LIMIT restrictions

  2. 2

    Performance considerations for SUB QUERY, LIMIT and ORDER BY when using MySQL

  3. 3

    MySQL NOT in Sub Query

  4. 4

    MySQL Sub Query difficulty

  5. 5

    mysql query based on value of previous row

  6. 6

    mysql select query php based on column value

  7. 7

    mysql query based on value of previous row

  8. 8

    Make a MySQL query fail by value based decision

  9. 9

    Print MySQL Output Based on Query String Value

  10. 10

    MySQL Query to find row duplicates based on condition with limit

  11. 11

    Overriding Data based on sub query

  12. 12

    Optimize MySQL query with dependent sub-query

  13. 13

    MySQL Query with Sub-Query optimisation

  14. 14

    Sub query to fetch the highest value

  15. 15

    Sub query to search for value in a column

  16. 16

    Replacing sub query with join in mysql

  17. 17

    MySQL sub query on the same table

  18. 18

    mysql sub query for find grade

  19. 19

    how to make mysql sub query

  20. 20

    MYSQL Sub Query with two columns

  21. 21

    like is not working in mySql sub query

  22. 22

    MySQL Sub Sub Query seems to loop

  23. 23

    Optimizing a sub-sub-query in MySQL

  24. 24

    3 MYSQL query using 1 query and limit

  25. 25

    MySQL Query add limit in SubQuery

  26. 26

    Limit characters in mysql query column

  27. 27

    Mysql complex query, group by with limit

  28. 28

    MYSQL query and LIMIT to one row

  29. 29

    Limit characters in mysql query column

HotTag

Archive