Home » Other » Training & Certification » retreive records
retreive records [message #261233] Wed, 22 August 2007 03:31 Go to next message
eur6lts
Messages: 4
Registered: August 2007
Junior Member
hi,
i need help to learn how to retreive all records that have
the same value and that the value appear at least in 2 record.

for eg the table is customers.
i need all customers that their city is the same and that the city appear at least at to customers

thanks

Report message to a moderator

Re: retreive records [message #261235 is a reply to message #261233] Wed, 22 August 2007 03:35 Go to previous message
Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use "group by", "having", and "count".

Regards
Michel

Report message to a moderator

Previous Topic: Real time scenarios of performance issues.
Next Topic: Oracle Apps DBA Course
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 16:28:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.