SELECT identical datas from one table

Posted in 2000

jenderka@my-deja.com — Mon, 28 Aug 2000 10:23:59 GMT — source: Informix-list mailing list archive (1991-1998)

I need SELECT expression to select all rows from one table where identical datas exist in one column. But I don't still know whether these datas exist. Therefore I cannot use WHERE. Have a nice day! -- Jenderka Vlastimil jenderka@post.cz Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to jenderka@my-deja.com

Christian Brauer — Mon, 28 Aug 2000 14:48:52 +0200 — source: Informix-list mailing list archive (1991-1998)

Hi, maybe you can try: SELECT your_column FROM your_table GROUP BY your_column HAVING COUNT(*) > 1 Hth, Chris Brauer jenderka@my-deja.com wrote: > I need SELECT expression to select all rows from one table > where identical datas exist in one column. > But I don't still know whether these datas exist. > Therefore I cannot use WHERE. > > Have a nice day! > -- > Jenderka Vlastimil > jenderka@post.cz > > Sent via Deja.com http://www.deja.com/ > Before you buy.

↪ replying to Christian Brauer

jenderka@my-deja.com — Thu, 31 Aug 2000 11:20:34 GMT — source: Informix-list mailing list archive (1991-1998)

Thanks. Now I use: SELECT column1, column2, column3, columnX FROM table WHERE column1 IN (SELECT column1 FROM table GROUP BY column1 HAVING COUNT(*) > 1);========================================================== In article <39AA5FB4.3DF85060@cbrauer.ruhr.de>, Christian Brauer <post@cbrauer.ruhr.de> wrote: > Hi, > > maybe you can try: > > SELECT your_column > FROM your_table > GROUP BY your_column > HAVING COUNT(*) > 1> > Hth, > > Chris Brauer > > jenderka@my-deja.com wrote: > > > I need SELECT expression to select all rows from one table > > where identical datas exist in one column. > > But I don't still know whether these datas exist. > > Therefore I cannot use WHERE. > > > > Have a nice day! > > -- > > Jenderka Vlastimil > > jenderka@post.cz > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > > -- Jenderka Vlastimil jenderka@mail.com or jenderka@post.cz e-mail code Windows-1250 -- Jenderka Vlastimil jenderka@mail.com or jenderka@post.cz e-mail code Windows-1250 Sent via Deja.com http://www.deja.com/ Before you buy.