> > >

MySQL MCQs

Consider a list of date ranges (range-start and range-end):

10/06/1983 to 14/06/1983

15/07/1983 to 16/07/1983

18/07/1983 to 19/07/1983

What will be the best way to find out if another date range containing any of the ranges already exists in the above list?

Select * FROM periods WHERE NOT (range_start > @check_period_end OR range_end < @check_period_start)

SELECT * FROM periods WHERE range_start <= @check_period_end AND range_end >= @check_period_start

Both Option A & B

None of the above

Answer

Correct Answer: Both Option A & B

Explanation:

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

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it