OracleConnections

Oracle Community Network

how to retrieve unmatched data from a column..

Hi All,

i have a column that contains 1 to 100 values but it has some missed data such as it does not has 50,45,34,23 etc..

so how could i find the missed data alone in a single query..

thanks

2 members like this

▶ Reply to This

Replies to This Discussion

Permalink Reply by Asa Labrecque on May 31, 2013 at 10:36am

from here

MINUS Example The following statement combines results with the MINUS operator, which returns only unique rows returned by the first query but not by the second:   SELECT product_id FROM inventories MINUS SELECT product_id FROM order_items;

▶ Reply

Permalink Reply by Marvin Cambre on May 31, 2013 at 10:37am

no no, i understand the concept of minus set operator, it is an interview question.. i just want to identy the missed numbers from 1..100 in a single query

▶ Reply

Permalink Reply by Asa Labrecque on May 31, 2013 at 10:45am

It appears you are dumping a bunch of interview questions in this forum

https://forums.oracle.com/forums/thread.jspa?threadID=2543023&t...
https://forums.oracle.com/forums/thread.jspa?threadID=2543024&t...
https://forums.oracle.com/forums/thread.jspa?threadID=2543021&t...
https://forums.oracle.com/forums/thread.jspa?threadID=2543026&t...

Bad enough in itself, but worse in that none of them have anything to do with the subject of this forum: "Database Security".
You go to an interview armed with your knowledge and experience. If your prep for an interview is to cram for it as if it were a test, one of two things will happen:
1 - If the people conducting the interview know anything at all they will quickly see through you and you won't get the job.
2 - You will get the job and both you and your manager will quickly discover that you are in way over your head.