Select top 1 record based on conditions

Babloo — Thu, 07 Mar 2024 05:59:09 GMT

I know this is not a direct SAS question but still if someone can help it would be nice. I'm connecting to Snowflake with explicit passthrough.

Any idea how to write the query like below without

This sql is not working due to 'unexcepted over'. I want to select the max of ntwk_cd group or partition by the field PBK

SELECT   top 1 * over(partition by PBK order by ntwk_cd desc)  FROM PRAC12
WHERE ID = '098'
and PBK=063;

Re: Select top 1 record based on conditions

Patrick — Thu, 07 Mar 2024 07:31:01 GMT

I never used it but based on documentation here I believe your are looking for the Snowflake QUALIFY clause.