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