SQL SELECT clause is used to specify which fields and in which order should be returned by the query. Fields in SELECT clause should be specified exactly in that order in which you want to get them returned.
Unless you want to extract all fields from the specified table (in which case * should be used) - you have to specify which fields RDBMS should return.
Login in to like
Login in to comment