Say select name , location from loc. Output: Name Loc
abc India abc England abc US xyz Autralia
I want to write a query , so that output will be: Name loc1 loc2 loc3 loc4
abc India England US Xyz Autralia
select name , location from loc. group by name
hth
bastien
