How can we help you today? How can we help you today?

SQL Prompt Suggestions do not appear in Row_Number clause

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
naumad
0

Comments

2 comments

Sort by
  • Michael Clark
    Hi Naumad,

    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?
    row_number() over (partition by col1, col2, col3 order by col0 desc) as x

    Best,

    Michael Clark
    Technical Lead, SQL Prompt
    Michael Clark
    0
  • naumad
    This is now working in v8.0.5.1758.
    naumad
    0

Add comment

Please sign in to leave a comment.