There are 4 Condition of SELECT command use.
1)FROM Specifies table to be used Where filters rows subject to some condition GROUP BY forms groups of rows with same col value
syntax
FROM tableName [alias] [,...]
2)HAVING filters groups subject to same condition
syntax
GROUP BY colList[HAVING Condition]
3)SELECT specifies which cols are to appear in the output
WHERE condition
syntax
SLECT [DISTINICT] | ALL {*|colExpression [As newName]] [,....]}
ORDER BY specifies the Oder of Output
syntax
ORDER BY [colList]
