SQL Prompt Suggestions do not appear in Row_Number clause
naumad
Posts: 19 Bronze 1
When writing a row_number() clause, sometimes there are no column suggestions or automatic alias prefixing for the partition or order phrases:
row_number() over (partition by col1, col2, col3 order by col0 desc) as x
row_number() over (partition by col1, col2, col3 order by col0 desc) as x
Comments
Sorry to hear that our column suggestions aren't always appearing.
Would it be possible to try updating to the latest version of SQL Prompt?
Have you managed to identify a pattern when the suggestions appear? Does it only affect col1 in your example or all columns?
Best,
Michael Clark
Technical Lead, SQL Prompt
Technical Lead, SQL Monitor