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, 2558🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...