manju00005 (6/5/2014)
select name,dept, punchdate ,status from Table_namewhere 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