MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table salesman (
  empid int,
  name text,
  gender text
);
insert into salesman values
(1, 'Suresh Raina', 'M'),
(5, 'Andrew', 'M'),
(7, 'Moeen', 'F'),
(11, 'Moeen', 'M');
select name, count(*) as counter,
  group_concat(concat_ws(',', empid, name, gender) separator '),(')
from salesman
group by name


name
counter
group_concat(concat_ws(',', empid, name, gender) separator '),(')


Andrew
1
5,Andrew,M

Moeen
2
7,Moeen,F),(11,Moeen,M

Suresh Raina
1
1,Suresh Raina,M


select
  name,
  count(*) as count,
  case when count(*) < 2 then ''
  else
  concat('(',
    group_concat(
      concat_ws(',', empid, name, gender)
      separator '),('
    ),
    ')'
  )
  end as flds
from salesman
group by name


name
count
flds


Andrew
1


Moeen
2
(7,Moeen,F),(11,Moeen,M)

Suresh Raina
1

name	counter	group_concat(concat_ws(',', empid, name, gender) separator '),(')
Andrew	1	5,Andrew,M
Moeen	2	7,Moeen,F),(11,Moeen,M
Suresh Raina	1	1,Suresh Raina,M