03-13-2018 01:32 AM
I am trying to pull records that are equal to 'Unknown' and DRG =469. What is wrong with my where statement?
select count(desy_sort_key) from etl.inp_claims_lds2013_2016 where Age_Range='Unknown' and clm_drg_cd ='469';
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
62 select count(desy_sort_key) from etl.inp_claims_lds2013_2016 where Age_Range='Unknown'
62 ! and clm_drg_cd ='469';
ERROR 180-322: Statement is not valid or it is used out of proper order.
64 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
Need further help from the community? Please ask a new question.