Comment Removed

shaunno2009 — Sat, 03 Apr 2021 11:11:13 +0000

Comment Removed

Every subquery needs an alias

teammatt3 — Tue, 04 Jan 2011 00:08:32 +0000

Every subquery needs an alias (or name). That "k" is just what I decided to call the subquery.

If you wanted to reference a specific column from that subquery, you would do something like:

SELECT 
  k.user_id,  # I am referencing a column from the subquery here
  k.username
FROM 
  (SELECT * FROM users ORDER BY points DESC LIMIT 3, 50) k 
ORDER BY 
  RAND()

If you had two columns named user_id (when you joined with another table), the k would resolve the ambiguity.

Use a subquery: SELECT * FROM

teammatt3 — Mon, 03 Jan 2011 18:30:15 +0000

Use a subquery:

SELECT * FROM (SELECT * FROM users ORDER BY points DESC LIMIT 3, 50) k ORDER BY RAND()