How to display the data once! 1

[choohean]

I got some data like this

ID Name Email
10 Tan tan@abc.com
10 Lee lee@pqr.com
10 Chong chong@mnp.com


I want to display the ID one only in other place.
How to write the query to get the ID for only once?

 

[kishleo]

can you please tell us clearly?
what do you mean by ID one in other place?

do you want to select only ID? if so you can group by ID ô¿ô Kishore

 

[choohean]

I was try to something like this

ID: 10

Name Email
Tan tan@abc.com
Lee lee@pqr.com
Chong chong@mnp.com

 

[bperry]

That's not something that's easy to produce with SQL, nor should you try. It's mostly a formatting problem, which should be done by the front-end tool generating the query (ASP, Crystal Reports, whatever...).

i.e. use a normal Select statement like:

Select ID, Name, Email from YourTable

and then have your FE tool print/display the resultset in the format you want.