| From: | Saulo Venâncio <saulo(dot)venancio(at)gmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | help on select |
| Date: | 2011-04-20 20:10:32 |
| Message-ID: | BANLkTinpuRYSkCkU7ovGojjAhbgXcLAP=g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi guys,
I need your help.
I have a table called medidas, in this table i have some ocurrences that has
id_medida(primary key) id_ponto (sec_key) and also datetime field as
timestamp.
i would like to know from a set of idpontos, e.g. 10,11,23,24.... how can i
get the most recent date that is common to all??
for example, if idponto das date 2011-02-03 but none of others have this
date in the db i dont want this. i want one common for all..
thanks.
*-----------------------
**Saulo B. M. Venâncio*
Control and Automation Eng. Student
*Associate in Business Management*
T +55 4884121486
*E saulo(dot)venancio(at)gmail(dot)com
*
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Charlie | 2011-04-21 08:03:27 | Re: help on select |
| Previous Message | Oliveiros d'Azevedo Cristina | 2011-04-20 16:12:05 | Re: How to realize ROW_NUMBER() in 8.3? |