Hi @rekhavs3779, Its true that "select *" gave us all the employee details in the partition query. But you can't use the same in the normal aggregate query, because whatever columns you provide in the select clause should be mentioned in the group by clause as well, which defeats the purpose of aggregation. But this is not the case with the window functions. Hope this helps.
![Seungmin "그렇게, 천천히, 우리(As we are)" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/kAzmhLHePqU/mqdefault.jpg)
Thanks for Detail explanation
Excellent, way of teaching essayly understandable hema mam
mam, isn't in time 4:46 we got employee details + salary for dept while using partition is because of select * ?
Hi @rekhavs3779, Its true that "select *" gave us all the employee details in the partition query. But you can't use the same in the normal aggregate query, because whatever columns you provide in the select clause should be mentioned in the group by clause as well, which defeats the purpose of aggregation. But this is not the case with the window functions. Hope this helps.
got it thanks mam@@TechWithHema
Detailed explanations. I like it. Can you make a course on joins please
excelent teaching mam thank you so much for share knowledage
please explain stored procedure ,explaining nicely soon you will get more views and subscribers all the best
@ravisudharshan Thank you. Keep supporting. Will make a video about stored procedure soon.
sure ,thanks @@TechWithHema
Detail explanation
mam please upload mssql full course video for beginners
Sure @magarajothik3144
Mam Rocked....