Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Group by select RE: Group by select

  • August 17, 2017 at 11:53 am

    #1955701

    Aditya-313343 - Tuesday, August 15, 2017 6:36 PM

    Hi,I need a help in writing a query.
    data looks like 
    ID           TAB NAME              Approved
    --------|------------------------|-----------------------------
    1              AB                           1
    1             CD                            0
    1             EF                            1
    2             AB                            0
    2             CD                            1
    2             EF                             1

    I want to write a query which returns
    ID               isABapproved?     ISCDApproved?          ISEFApproved?
    -----------------------------------------------------------------------------------------------
    1                YES                          NO                                YES
    2                 NO                            YES                            YES

    Select Id,
    Max(case when Tabname = 'AB' and Approved = 1 then 'Yes' Else 'No' end) as ISABApprove ,
    max(case when Tabname = 'CD' and Approved = 1 then 'Yes' Else 'No' end) as ISCDApprove,
    MAx(case when Tabname = 'EF' and Approved = 1 then 'Yes' Else 'No' end) as ISEFApprove
    from table1
    group by ID