After reading multiple posts which contain a "Select * from" - statement, i thought it would be good idea to repost something that should be common knowledge.
Don't write "Select From" statements. Not ever. Most of the time, not all columns of a table are needed and selecting all there are puts unneccessary load on the server.
Even if you need all columns, there are good reasons to list them explicitly, even if it's more tedious than a simple "":
it's possible you'll expand the table in the database, but won't need the additional information in every place you wrote "Select *"
the order the columns are returned in is usually the same as the order the columns were defined in. This order could change! All it takes is an update to your database system e.g. or reversion to a backup.
listing each of the columns in your select statement allows you do use "AS" to define an alias for each column; e.g. Select emp.w_ph_nr as workPhoneNr ...
This has got the added benefit of increasing the readability (and thus, the adaptability) of your code
