write a query to get the output as below?

Jul 16 2016 1:21 PM
ID       Name
 
1         1
2         2
2         2
3         3   
3         3
3          3
 
how write query this type of output

Answers (4)