I get the following error when I execute the SELECT statement seen below...
You tried to execute a query that does not inclue the specified expression 'questioncode' as part of an aggregate function.
SELECT questioncode, MAX(regulatoryanswer), inpracticeresponse from vmasterdata where questioncode = 'GQ-005' and regulatoryanswer like "*Day*" or regulatoryanswer like "*Month*"
I am trying to get the largest value in the regulatory column.
This statement works fine without the MAX.
Could somebody help with this and tell me what I am doing wrong?