SQL - Part 50 - Group By Clause

In this video, I have explained and practically demonstrated using the 'Group By' Clause in SQL statements.

[vishnuvamshi]

I want all records in table but I want to use groupby how to get the result in SQL..
Eg:- select empno, empjob from emp
Group by empno, empjob
With this query I get only empno and empjob in the result but not the entire table is seen how to solve this problem?

[yadojunaveen]

How to get data in this table like as u shown in vedio