I have a table in sybase with following data.

F_Name L_Name, Phone

F1 L1 P1
F2 L2 P1
F3 L3 P2
F4 L4 P4

I want to write a query which selects distinct phone number and only one F_Name and L_Name .

Output should be ,

P1 F1 L1
P2 F3 L3

or

P1 F2 L2
P2 F3 L3.

etc..

I can write the query with cursor or using aggregate function as follows

select phone, min(F_Name), min(L_Name) from table
group by phone

Is there any alternate way ?

Thanks

One more alterneative will be..

Select Phone, F_Name, L_Name into #tbl1 from yourtbl where 1= 2

Select distinct phone,’ ‘,’ ‘ into #tbl1
Update #tbl1
Set F_Name = b. F_Name, L_Name =b. L_Name
From #tbl1 a, yourtbl b
Where a. phone = b. phone

If this is the way the data is going to be used I would redesign the table..