How to use group by clause in sub query?

Answer 1

When using sub query make sure you use the same column name as mentioned in group by. Otherwise it will throw an error. You could use scalar function like avg, max.. Etc in select clause

Example
Select * from Tablename where id in ( select id from idtable group by id having count(id) >2.

Answer 2

just in the same way that we use on the queries

Answer 3

select * from table_name where attribute_name in (select *from table_name where condition group by attribute_name)

Answer 4

Use same as normal