Answers

Question and Answer:

  Home  MS SQL Server

⟩ 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

 136 views

More Questions for you: