Question

mention the clauses used while using select statement in a table

Answer 1

The SQL SELECT statement returns a result set of records from one or more tables. ... HAVING selects among the groups defined by the GROUP BY clause. ORDER BY specifies an order in which to return the rows. AS provides an alias which can be used to temporarily rename tables or columns.