Select from following answers:- Acts like a WHERE clause but is used for groups rather than rows.
- Acts like a WHERE clause but is used for rows rather than columns.
- Acts like a WHERE clause but is used for columns rather than groups.
- Acts like a WHERE clause but is used for columns rather than groups.
- All Above
Having Caluse acts like a WHERE clause but is used for groups rather than rows. Having clause is written after Group By clause.
For Example:-
select employee_id from employement_history
group by employee_id having count(employee_id)>1;
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator