how to display single column in different column in sql

i am having like this

Code:
DATE		NAME	COUNT
01-03-2013	JHON	500
01-03-2013	JONY	2800
01-03-2013	ANAND	3500
01-03-2013	RAM	2300
01-03-2013	VINOD	500
01-04-2013	JHON	500
01-04-2013	JONY	2800
01-04-2013	ANAND	3500
01-04-2013	RAM	2300
01-04-2013	VINOD	500
i want to display like

Code:
NAME	OPEING
...