Re:User-defined Order in SQL
by chiph on Wednesday March 21, 2018 @12:06PM
(#16639362)
We did #1 at a previous job - the users wanted their common countries in a list of countries to appear at the top of the drop-down (US, Canada, Germany, etc) and not in the natural sort position. It was something that practically never got changed once it was set up, so the update problem was handled manually via DBA scripts.
[ Parent
| on HN ]
Re:User-defined Order in SQL
by yellowapple on Wednesday March 21, 2018 @04:16PM
(#16641934)
You could probably do #1 pretty easily with a descending sort on each country's population.