Select Statement with asterisk (*) or Select "star" returns all of the columns in a table.

SELECT * FROM Table_Name

Ex:

Results:

 If you do not need to return all of the columns in your table you should specify the columns that you need to improve query performance.  Also, if you are using the SQL statement in an application listing your columns will help with troubleshooting your query.

SELECT Column1,

Column2,

Column3

FROM Table_Name

Ex:

Results:

SQL Tutorial