MS SQL Server 2012 - DBA Articles

SELECT - Display Particular Columns of Records



SQL Server allows you to retrieve one or many columns records from a table. An example, the following query is used to displays particular column(s) records from PRODUCT table.

-- Example 20 --

 

SELECT Prod_Name FROM Product

 

SELECT Prod_Name, Batch_No, Exp_Date FROM Product


Query Output Screen



* * * * *


Email Your Comment To AUTHOR