6 ms·
What would you prefer to see instead, bearing in mind that anything you will suggest is likely to bsave minimal typing but introduce new complexity into sql whi
by zasdffaa 4y ago
What would you prefer to see instead, bearing in mind that anything you will suggest is likely to bsave minimal typing but introduce new complexity into sql which everyone agrees is already creaking like a constipated elephant.
- PaulHoule 4y agosomething like a function or macro CREATE MACRO count_values(this, that) WITH DEFINITION SELECT this,COUNT(*) FROM that GROUP BY this
- RyanHamilton 4y agoHow about always returning the "group" column by default. If the user wants to get rid of it later (much less frequent) they can do an outer select or remove the column themselves.
- zasdffaa 4y agoPlease give an example.