By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.