MS SQL Server 2012 - DBA Articles |
SELECT - Display Particular Columns of RecordsSQL 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 |
* * * * *