I was feeling charitable this morning so I created the ddl and sample data to work with.

if OBJECT_ID('tempdb..#Data') is not null

drop table #Data

create table #Data

(

MyName varchar(20),

Age int,

Salary int,

Department varchar(20)

)

insert #Data

select 'SHARATH', 24, 21000, 'MARKETING' union all

select 'RATHAN', 35, 21000, 'MARKETING' union all

select 'RATS', 28, 21000, 'IT' union all

select 'DARSHAN', 23, 20000, 'IT' union all

select 'LINI', 25, 25000, 'IT' union all

select 'SHAN', 23, 20000, 'MARKETING' union all

select 'SUDARSHAN', 22, 20000, 'IT'

select * from #Data

If the OP can confirm this will work we can figure out what they want as output and proceed from there.