What are the challenges you face when working across database platforms? Take the survey

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.