Re: SELECT identical datas from one table

You can add a COUNT(*) if you need how many times the data exists: SELECT your_column,COUNT(*) FROM your_table GROUP BY your_column HAVING COUNT(*) > 1 --- Christian Brauer <post@cbrauer.ruhr.de> escribi': > 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. > > > ===== ______________________________________ Luis Carlos D'az Otero ALCANOS DE COLOMBIA S.A. E.S.P Carrera 9 # 7-25 Neiva (Huila (Colombia)) __________________________________________________ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/