Collections:
Selecting Some Specific Columns from a Table in SQL Server
How To Select Some Specific Columns from a Table in a Query in SQL Server?
✍: FYIcenter.com
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
2016-10-26, 3894🔥, 0💬
Popular Posts:
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...