| From: | Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
| Subject: | Re: Trayendo repetidos |
| Date: | 2006-03-02 20:24:42 |
| Message-ID: | 200603021724.43091.martin@bugs.unl.edu.ar |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
El Jue 02 Mar 2006 17:19, Alvaro Herrera escribió:
> Martin Marques escribió:
> >
> > Suponiendo que queres los registros de la tabla tab1 que repita la
> > columna col1:
> >
> > SELECT count(*) contador,col1 FROM tab1 WHERE contador > 1 GROUP BY col1
>
> select id from tab group by id having count(id) > 1;
Uff, necesito urgente un cafe (cargado)!
--
17:23:57 up 3 days, 1:56, 3 users, load average: 1.02, 0.97, 0.82
---------------------------------------------------------
Lic. Martín Marqués | SELECT 'mmarques' ||
Centro de Telemática | '@' || 'unl.edu.ar';
Universidad Nacional | DBA, Programador,
del Litoral | Administrador
---------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | tania gutierrez | 2006-03-02 20:25:20 | Ayudaaaa, bloqueo de filas o tablas |
| Previous Message | Alvaro Herrera | 2006-03-02 20:19:50 | Re: Trayendo repetidos |