SQL Server Accessing Data Questions and Answers

SELECT is used to select a specific or ALL columns / rows from a table.......
DISTINCT: Distinct clause helps to remove duplicates and returns a result set. Syntax: DISTINCT (set_expression)........
INTO: The INTO keyword inserts data from one table into another. It is commonly used in SELECT statement. It is useful in creating back ups.........
WHERE: Where clause in a SELECT query is used to retrieve specific records that meet the specified criteria.......