When can you use select *
Alex has a great post questioning whether you should
ever go against the "never use select * " mantra.
I for one think Alex has a valid point. The only point against select * is
that you have to look elsewhere to find out the columns that are being
However if you already have the list of columns in your query then its just a
cut and paste to put them in the top level select.
and finally its only going to save you a few seconds. Far more than its taken
to read Alex's post and for me to write this one. So just be a good citizen of
planet SQL and "don't use select *".