Selecting Some Specific Columns from a Table in SQL Server

Q

How To Select Some Specific Columns from a Table in a Query in SQL Server?

✍: FYIcenter.com

A

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 "fyi_links":

SELECT id, created, url FROM fyi_links
id      created      url
101     2006-04-30   dev.fyicenter.com
102     2007-05-19   dba.fyicenter.com
103     2007-05-19   sqa.fyicenter.com

 

⇒ Selecting Some Specific Rows from a Table in SQL Server

⇐ Selecting All Columns of All Rows from a Table in SQL Server

⇑ Using SELECT Statements and GROUP BY Clauses in SQL Server

⇑⇑ SQL Server Database Tutorials

2016-10-26, 3894🔥, 0💬