/*
table data contins like id,name,sal
1,abc,1200
2,jaid,5300
3,union,1000
4,ravod.200

i want output like
id , name, sal , max(sal), min(sal)
1 ,abc ,1200 , null , null
2 ,jaid ,5300 , yes , null
3,union , 1000 , null ,null
4,ravod ,200 ,null , yes

*/
create table #TestTable(
    id int,
    name varchar(10),
    salary int
);
go
insert into #TestTable
values
    (1,'abc',1200),
    (2,'jaid',5300),
    (3,'union',1000),
    (4,'ravod',200);
go
with MaxSalary as (
select
    max(salary) MaxSalary
from
    #TestTable
), MinSalary as (
select
    min(salary) MinSalary
from
    #TestTable
)
select
    id,
    name,
    salary,
    case when MaxSalary is not null then 'Yes' end MaxSalary,
    case when MinSalary is not null then 'Yes' end MinSalary
from
    #TestTable tt
    left outer join MaxSalary ms1
        on (tt.salary = ms1.MaxSalary)
    left outer join MinSalary ms2
        on (tt.salary = ms2.MinSalary)
go
drop table #TestTable;
go