Hi Everybody..
Let's present my problem:
I have a table named t1 and i will insert differents values like this :
insert into t1 (num,father,child,age) values ('1','joe','bruce','14',);
insert into t1 (num,father,child,age) values ('1','joe','lei','10',);
insert into t1 (num,father,child,age) values ('1','joe','mike','5',);
when i use select * from t1 i obtain:
num father child age
1 joe bruce 14
1 joe lei 10
1 joe mike 5
i want to have
num father child age
1 joe bruce 14
lei 10
mike 5
what can i do as select request to obtain this capture?
Thanks :)
