Explain some of the keywords of Select Statement like Distinct Keyword, Top n Keyword with an example for each of them.
DISTINCT: Distinct clause helps to remove duplicates and returns a result set.Syntax:
Select DISTINCT company_name FROM Company;
TOP N: returns the top “n” records from a table.Syntax :
Select TOP 10 Cust_name from Customer;