Home » RDBMS Server » Server Administration » Help Me simply Query
Help Me simply Query [message #370408] Tue, 21 September 1999 10:31 Go to next message
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.
Re: Help Me simply Query [message #370409 is a reply to message #370408] Tue, 21 September 1999 17:03 Go to previous message
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: Tue Oct 20 10:17:59 CDT 2020