| From: | Jaime Casanova <systemguards(at)gmail(dot)com> |
|---|---|
| To: | Zuleima Lara <zlara(at)interactivedata(dot)com(dot)ve> |
| Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
| Subject: | Re: Ayuda con "DISTINCT ON" |
| Date: | 2005-12-19 16:48:00 |
| Message-ID: | c2d9e70e0512190848y14d29684i33a5d0fd3e84857@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
On 12/19/05, Zuleima Lara <zlara(at)interactivedata(dot)com(dot)ve> wrote:
> Hola....
> Disculpa, me podrias indicar como podria hacer lo del ORDER BY 1?
>
SELECT distinct on
(
(SELECT estado FROM Minorista WHERE Min = ''minorista 1''),
(SELECT descripcion FROM Productos WHERE prov = ''prov 1'')
)
(SELECT estado FROM Minorista WHERE Min = "minorista 1") as estado,
(SELECT capital FROM Minorista WHERE Min = "minorista 1") as capital,
(SELECT descripcion FROM Productos WHERE prov = ''prov 1'') as descripcion,
(SELECT precio FROM Productos WHERE prov = ''prov 1'') as precio,
FROM AlmacenMnBS
WHERE Min = "minorista 1" AND prov = ''prov 1'' AND fecha = ''10/25/05''
ORDER BY 1, fecha DESC, hora DESC
--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | WILLIAM PARRA | 2005-12-19 17:02:14 | Re: Saludos - Obtener los ultimos caracteres de una cadena |
| Previous Message | Jaime Casanova | 2005-12-19 16:41:58 | Re: Saludos - Obtener los ultimos caracteres de una cadena |