Clause In Select Statement

• SELECT 

             SELECT * FROM table_name;

• WHERE CLAUSE

              SELECT * FROM table_name WHERE condition_statement;

• DISTINCT CLAUSE

             SELECT DISTINCT Column_Name1, Column_Name2 From table_name;

• AND/OR Clause

              SELECT Column_Name1, Column_Name2 FROM table_name WHERE Condition_Statement1 (AND/OR) Condition_Statement2;

• IN Clause

             SELECT Column_Name1, Column_Name2 FROM table_name WHERE Column_Name (value1, value2……….valuen);

• BETWEEN Clause

             SELECT Column_Name‘s FROM table_name WHERE Column_Name BETWEEN value1 and value2;

• LIKE CLAUSE

             SELECT * FROM table_name WHERE Column_Name LIKE (statement);

• ORDER BY CLAUSE

            SELECT * FROM table_name WHERE Condition ORDER BY Column_Name (ASC/DESC);

• GROUP BY CLAUSE

           SELECT SUM (Column_Name) FROM table_name WHERE Condition GROUP BY Column_Name;

• COUNT CLAUSE

           SELECT COUNT (Column_Name) FROM table_name WHERE Condition;

• HAVING CLAUSE

            SELECT SUM (Column_Name) FROM table_name WHERE Condition GROUP BY Column_Name HAVING (Arithematic_Condition);