SQL Select Statement

 The SELECTstatement has the following clauses:

Select distinct rows using DISTINCT operator.

Sort rows usingORDER BY clause.

Filter rows using WHERE clause.

Select a subset of rows from a table using LIMIT or FETCH clause.

Group rows into groups using GROUP BY clause.

Filter groups using HAVING clause.

Join with other tables using joins such as INNER JOINLEFT JOINFULL OUTER JOINCROSS JOIN clauses.

Perform set operations using UNIONINTERSECT, and EXCEPT.

Comments

Post a Comment

Popular posts from this blog

What is Tableau and important Role in details ?