Learn Little bit More

1. An aggregate function does not accept sub query as an input. Example Having sum (select ...)>5 2. Processing order for 'ON' and 'WHERE'           a)ON            b)WHERE 3.'Distinct' and 'Order by ' can't be used in the same query. 4. Table is organised in one of these ways (Heap ,B-tree).Table organization is called "HOBT" 5. Extent has 8 pages. Each page has 8kb.

1. ON 2. WHERE 3. HAVING  The above 3 keywords are considered as query filters in SQL.

It's very important to know that how SQL query is processed inside whenever we execute it.  1. FROM - Left to Right 2. WHERE 3. GROUP BY 4. HAVING 5. SELECT 6. ORDER BY 7.  OFFSET/FETCH