Query required to display a row from table

[AdusumalliGopikumar]

Hi,

Could you please help me?

The table is given below

Name Phone No
-------------------------------
A 1
A 2
A 3
B 1
B 2




Now I want to display the row as shown below

Name Phone1 Phone2 Phone3

A 1 2 3




How can I display like this please provide me the query/solution.



Thanks in advance,

Gopikumar A

[sfabbas]

U can do that making use of plsql
as it's easier to do in plsql rather in sql
if u need i will write a proc for u

[debasisdas]

Kindly post what you have tried so far.

[amitpatel66]

Will a person have not more than 3 phone numbers?
In case if the phone no are more than 3 for a particular person, in that case??