[SQL] Postgres-sql-php

[Zied Kharrat]

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 bruce14
1   joe lei 10
1   joe mike 5


i want to have

*num  father  child age*
1   joe bruce14
   lei 10
   mike 5

what can i do as select request to obtain this capture?

Thanks :)

Re: [SQL] Postgres-sql-php

[Zied Kharrat]

hi,

i don't want any sort..  just like this example

*num  father  child age  col5
*1   joe bruce14   8
   lei 10
   mike 5

2manuel  child135  16
  child233
  child3   30


this is what i want really..

What can be then the sql request without sort with this update.. Thanks :)