How is SQL Prompt helping your team? Share your experience.

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


Sign In or Register to comment.