⟩ How To Select Some Specific Columns from a Table in a Query in MS SQL Server?
If you want explicitly tell the query to return some specific columns, you can specify the column names in the SELECT clause. The following select statement returns only three columns, "id", "created" and "url" from the table "ggl_links":
SELECT id, created, url FROM ggl_links
id created url
101 2006-04-30 www.rendc.org
102 2007-05-19 www.rendc.org/html
103 2007-05-19 www.rendc.org/sql