Skip to content
← SQL Complete

How can we improve SQL Complete?

SQL Complete

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Row_number() formatting issue

Formatting for rownumber() seems to have issues with breaking up the line. I don't know if the parser is evaluating it as a possible subquery, but it would be great to have the option for a single line or wrapped line rownumber(). A row_number() statement on 4-5 lines seems to be a little confusing.

3 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Sheldon shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
AdminDevart (_, Devart) responded  · 

Could you please provide us a concrete example demonstrating this and describe it in more detail?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • AdminDevart (_, Devart) commented  ·   ·  Report

    row_number() with order by statement seems to be following the select/order by line break logic. Most folks I've seen online use the same single line syntax for most row_number operations. I'd like the option to customer the row_number() formatting in a select statement, maybe to allow wrapping when certain length exceeded.

  • Sheldon commented  ·   ·  Report

    I'm getting erratic results on this. Looks like maybe the latest update fixed? Please close and I'll repost the issue if it occurs again.
    thanks!