3706: Syntax error: expected something between ')' and '='.
I know this question is alfready asked , but any help in resolving this issues is appreciated.
Iam trying to run the following query & geeting the error:
select count(pr_id) as keycount, pr_id, pr_dsc , ( CASE WHEN ( select distinct count(run_id) from PR) = (select distinct coun (pr_id) from PR) THEN 'CORRECT SG' ELSE ' Wrong SG inserted' END ) from PR group by pr_id , pr_dsc
The error message is as follows: Code = 3706. 3706: Syntax error: expected something between ')' and '='. Output directed to Answer set window