Suppose we have a requirement to fetch a record on basis of a condition.
select records from the table on the basis of where clause and sort them by group by clause.
Normally we used to code it like
where salary>10000 --optional
group by first_name,salary;
What I have tried:
where condition --optional
group by col1,col2;