help with simple sql

Posted in 2000

dios — Mon, 26 Jun 2000 09:46:08 -0700 — source: Informix-list mailing list archive (1991-1998)

Hola guru's, What is the correct informix syntax for selecting all rows where the one column contains duplicates and the selection criteria is only on the one column? Right now I am running comparisons against the orig and a temp table. table: column 1 col 2 ss01 01 ss02 ss01 02 ss03 ss01 03 ss04 01 ss04 02 ss05 output: col 1 ss01 01 ss01 02 ss01 03 ss04 01 ss04 02 search criteria is col 1 only! ss03 and ss05 are not included because they are unique tia