Select top 1 record based on conditions

[Babloo]

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

• introducing any new fields,
• using exclude keyword
• using CTE
• using all the fields in group by

 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;

[Patrick]

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