I have a very large table , and from that table I need just 2 records with column1 = 'A' and column1 = 'B' . Here I don't think if I can not use OR or IN or Case operators because I need exactly 2 records not more.
One more thing I want to make this query efficient because there is no point iterating the whole huge table where maybe 1st and 2nd record hold those values (A and B) . Similarly I want to iterate the whole table unless both the values are found . Thanks