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

Views: 40

Reply to This

Replies to This Discussion

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;

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

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.

Reply to Discussion

RSS

© 2020   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service