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.
Dig Deeper on Open source databases
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.