select A.col1,A.col2,A.col3,A.col4,A.col5,A.col6,A.col7,C.col8,case when B.col1 is null then 'False' else 'True' end From
(
select * from xyz
)A
left outer join
(
select col1=max(col1),col2 from abc
group by col2
)B
on B.col1=A.col1
inner join def C on C.col1=A.col1
order by a.col2
Manas MohapatraPosted Aug 26, 2016, 8:39 AM