group by is always tied together with an aggrigate function in sql

Solutions on MaxInterview for group by is always tied together with an aggrigate function in sql by the best coders in the world

showing results for - "group by is always tied together with an aggrigate function in sql"
Joanna
22 Nov 2020
1SELECT NAME, SUM(SALARY) FROM Employee 
2GROUP BY NAME
3HAVING SUM(SALARY)>3000; 
4
Evan
14 Oct 2018
1SELECT SUBJECT, YEAR, Count(*)
2FROM Student
3GROUP BY SUBJECT, YEAR;
4
similar questions