I'm trying to refine a mysql query so that it will return rows with the highest values in the "Version ID" column.
Here is the query:
n_vid) AS MAX_question_vid
FROM quiz_node_relationship RIGHT OUTER JOIN quiz_multichoice_answers ON quiz_node_relationship.chi
ld_nid = quiz_multichoice_answers.q
ent_nid = '23'
GROUP BY quiz_node_relationship.par
ORDER BY quiz_multichoice_answers.q
d ASC, MAX_question_vid DESC
I'd like to have the table show only the records with the highest question_vid for a given question_nid.
I don't understand why the MAX function doesn't achieve this here, but my mySQL chops are limited... thanks for the help.
I've attached an image of the resulting table.