4 ms·
The order of the columns in your table creation statements is irrelevant to the order of how the columns return to you in your queries. Your select statement s
by rangerelf 4y ago
The order of the columns in your table creation statements is irrelevant to the order of how the columns return to you in your queries.
Your select statement specified the order of your result columns in your result set. Your visualization tools should have the option to reorder the displayed columns to your liking or need.
- HNBRN 4y agoThanks. I checked and dbeaver can indeed store columns ordering as a filtered view. Seems like a bit overcomplicated to me but I guess I've been spoiled with mysql in which the ordering is trivial.
- sargstuff 4y agovisual example : https://www.w3resource.com/sql-exercises/sql-retrieve-exercise-7.php https://www.w3resource.com/sql-exercises/sql-retrieve-exerci... verbal examples : discussion on various ways to reorder columns : https://stackoverflow.com/questions/1605144/how-to-change-co https://stackoverflow.com/questions/1605144/how-to-change-co...