What is 1 DISTINCT 2 GROUPING 3 HAVING 4 JOIN 5 SUBQUERY 6 T

What is: 1. DISTINCT? 2. GROUPING? 3. HAVING? 4. JOIN? 5. SUBQUERY? 6. TRIGGER? 7. CURSOR? 8. VIEW? 9. NULL? 10. DDL?

Solution

1. DISTINCT:

The DISTINCT is a keyword in SQL used as conjunction with SELECT statement to remove all the duplicate records. And to fetch unique records only.

The syntax for DISTINCT keyword is:
SELECT DISTINCT column1, column2,.....columnN
FROM table_name
WHERE [condition]

2. GROUPING:

Syntax of GROUPING is

GROUPING ( <column_expression> )

3. HAVING:

It is a condition applied only to the aggregated results to limit the groups of returned rows.

4. JOIN:

5. SUBQUERY:

6. TRIGGER:

7. CURSOR:

8. VIEW:

9. NULL:

10. DDL: