| From: | "Loredana Curugiu" <loredana(dot)curugiu(at)gmail(dot)com> |
|---|---|
| To: | "Richard Huxton" <dev(at)archonet(dot)com>, pgsql-novice(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: [SQL] Select last there dates |
| Date: | 2007-06-21 13:33:06 |
| Message-ID: | 1c23c8e70706210633g234e06a1qb25558091e572971@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-sql |
>
>
> I think there might be a small typo though. The left-join is to:
> (select uid, phone_numer, datum from t2 order by 2 )
> Probably want to order by "datum DESC" too, to ensure you get the latest
> dates for each telnum.
yes, I also observed this, so I have add to my query.
Thank you for your explanations, Richard.
Best regards,
Loredana
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Loredana Curugiu | 2007-06-21 13:35:37 | Re: [SQL] Select last there dates |
| Previous Message | A. Kretschmer | 2007-06-21 13:24:40 | Re: [SQL] Select last there dates |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Loredana Curugiu | 2007-06-21 13:35:37 | Re: [SQL] Select last there dates |
| Previous Message | A. Kretschmer | 2007-06-21 13:24:40 | Re: [SQL] Select last there dates |