Re: build a query

"Paolo Fossati" <fossati_apoloNOSPAM_at_hotmail.com> a écrit dans le message de news: 4e4bd509$0$6840$5fc30a8_at_news.tiscali.it...
| hi all,
|
| i'm trying (with no success ) to build an oracle query , db is oracle
| 10, os windows 2008 64 bit
|
| in a table called "location" i have :
|
| REF location object_count
|
| 1000 a 22
| 1000 b 22
| 1001 a 57
| 1001 b 55
| .
| .
| .
|
| the same object (see the 1001 example ) is existing in 2 different
| locations (a and b) but the number on objects are not the same (in one
| place are 57, in the other 55)
| As this number must be the same in all the locations for the same ref
| (see the 1000 example), how can i spot with query all the refs thar are
| not the same?
|
| thanks a lot fot your help
| Paolo

All are different or some are different?

Regards
Michel Received on Wed Aug 17 2011 - 10:36:03 CDT