SQL HAVING and SELECT possible attributes

Question

In SQL-92 (which is what GATE assumes), which columns are allowed in SELECT and HAVING, when GROUP BY is present or not ?

Which columns/attributes can be aggregated or non aggregated in SELECT and HAVING?

I can't find good, clear info relating this.

Answer 1

SELECT and HAVING have different purposes. A better comparison would be between WHERE and HAVING.

 

WHERE is to place a condition to select rows that match the condition.

HAVING is used along with GROUP BY only, as its function is to select only those groups that match the given condition. As you know, GROUP BY is used only with an aggregate function.

Hope this answers the question.

Comments

Thanks for your answer, but I wanted to know what possible attributes can be present in SELECT, and HAVING clause in different cases. For example I know that HAVING clause can only contain attributes present in GROUP BY.

I want to all such rules for the two clause for the cases when GROUP BY is present or not.

Thanks.

---

@shc 

hope this video servers your query : SQL Lecture About GroupBy and it's aggregation