Options

GROUP BY Feature Request / Enhancement

aultmikeaultmike Posts: 43
edited April 20, 2010 5:33PM in SQL Prompt Previous Versions
Hello,

I wanted to suggest an enhancement to your SQL Prompt product.. which I *LOVE* by the way!

If I type

SELECT City, State From Addresses

and I begin to type GROUP BY and press the space bar ... I think it would be awesome for the first suggestion in the intellisense to be City, State. Because If I explicitly type n number of columns I think it would be safe to assume that I want to aggregate on these columns.

I also believe that it would be cool if the ORDER BY operated the same way as the GROUP BY.
· Share on Twitter

Comments

  • Options
    MikeyCMikeyC Posts: 249 Bronze 3
    I second this suggestion. Though I would add that it might make sense to leave out aggregate fields from the SELECT clause. (Though it wouldn't be a big deal to delete them manually.) As it is now I usually select, copy, and paste the fields from the SELECT portion of the statement for the GROUP BY and ORDER BY.
    · Share on Twitter
Sign In or Register to comment.