select num from request where num in (select max(num) from request group by num2)I get the #1064 error ("You have an error in your SQL syntax"), and I don't know why. According to the documentation, my syntax is correct. Any thoughts?
Subqueries are only available from MySQL 4.1 and higher. You will need to upgrade.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.