OraFAQ Forum: Server Administration » Help Me simply Query

Home » RDBMS Server » Server Administration » Help Me simply Query

Tue, 21 September 1999 10:31

Prashantha
Messages: 2
Registered: September 1999

Junior Member

How can get Number Of Distinct record where record has column's (More then one) from the table.

Tue, 21 September 1999 17:03

m a sivan
Messages: 34
Registered: July 1999

Member

select <FIELD LIST> from tablename
group by having count(*) >1
should do ur Query I guess.

Do let me know ur specific requirement

Previous Topic:	Re: simple query
Next Topic:	sequence doesn´t work on new ora-instance

Goto Forum:

]

Current Time: Fri Feb 07 22:56:57 CST 2025