Consider Employee table and answer. Which of the given options will give the following result? - Access

> > >

Access MCQs

SELECT Name, State, Mobile_no FROM Employee WHERE State IN ('KN', 'TS')

UNION

SELECT Name, State, Mobile_no FROM Employee WHERE IN ('OP’ 'TS')

SELECT Name, State, Mobile_no FROM Employee WHERE State lN ('KN', 'TS')

UNION ALL

SELECT Name, State, Mobile_no FROM Employee WHERE IN ('OP' 'TS')

Both options a and b.

Neither option a nor b.

Answer

Correct Answer:

SELECT Name, State, Mobile_no FROM Employee WHERE State lN ('KN', 'TS')

UNION ALL

SELECT Name, State, Mobile_no FROM Employee WHERE IN ('OP' 'TS')

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Access Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it