Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Selecting unique records
Ooops, I meant to say 'order by 2' in the above post. You want to order by the count. Sorry....- DannyO
- Post #6
- Forum: Oracle: All versions
-
Selecting unique records
A script I often use to find unique records (and dupes) is the following: select distinct Serial_num, count(*) from my_table group by serial_num order by 1; This will list the field value and the number of recs with that value and it will order the output from lowest count to highest. If you...- DannyO
- Post #5
- Forum: Oracle: All versions
-
Oracle 9i installation problem (ociw32.dll access denied)
You do need to delete registry entries. I never trust Oracle deinstall process in Windows. It removes programs and files but leaves several references in the registry. The new install may still find them being used or locked or something. Please refer to Oracle MetaLink doc ID 124353.1. If...- DannyO
- Post #2
- Forum: Oracle: All versions
