On-demand training: More Gems from the SQL Prompt Treasure Chest. Watch now.

SQL Prompt Suggestions do not appear in Row_Number clause

naumadnaumad Posts: 19 Bronze 1
edited March 16, 2017 1:47PM in SQL Prompt
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

Comments

Sign In or Register to comment.