• manju00005 (6/5/2014)


    select name,dept, punchdate ,status from Table_name

    where name='robin'

    select name,dept, punchdate ,status from Table_name

    where name='Alex'

    The original question was about formatting, not about how to select the data.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP