Convert SQL Server query to MySQL [duplicate]

by

This is actually a duplicate question, but I now have a better, single-pass, fast, answer:

SELECT *
FROM
(
    SELECT tbl.*, @counter := @counter +1 counter
    FROM (select @counter:=0) initvar, tbl
    ORDER BY ordcolumn
) X
WHERE counter <= (50/100 * @counter)
ORDER BY ordcolumn;

More Related Contents:

  1. SQL Query needed for fetch value from Two identical table but not fully identical table
  2. sql query to modify the selected value from database [closed]
  3. Calculate Average of the largest values in multiple columns
  4. SQL Print the name of all Employees together with the name of their supervisor
  5. Storing JSON in database vs. having a new column for each key
  6. SQL: Repeat a result row multiple times, and number the rows
  7. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  8. Why do results from a SQL query not come back in the order I expect?
  9. When to use SELECT … FOR UPDATE?
  10. Best practices for SQL varchar column length [closed]
  11. How to transpose rows to columns with large amount of the data in BigQuery/SQL?
  12. how to cast the hexadecimal to varchar(datetime)?
  13. Equivalent of MySQL ON DUPLICATE KEY UPDATE in Sql Server
  14. Why in SQL NULL can’t match with NULL?
  15. comparison of truncate vs delete in mysql/sqlserver [duplicate]
  16. Error related to only_full_group_by when executing a query in MySql
  17. SQL split values to multiple rows
  18. MySQL Cannot Add Foreign Key Constraint
  19. Grouping into interval of 5 minutes within a time range
  20. Convert timestamp to date in MySQL query
  21. Update a column value, replacing part of a string
  22. mysql dynamic query in stored procedure
  23. MySQL Insert Into from one Database in another
  24. MySQL multiple columns in IN clause
  25. How to select one row randomly taking into account a weight?
  26. GROUP BY – do not group NULL
  27. Composite key as foreign key (sql)
  28. Sort the rows according to the order specified in WHERE IN clause
  29. How can I use SQL’s YEAR(), MONTH() and DAY() in Doctrine2?
  30. MYSQL Select One Random record from each Category

Leave a Comment