Menu
Home / CSE MCQs / MySQL Database MCQs :: Discussion

Discussion :: MySQL Database MCQs

  1. Find the error in the following query?

    SELECT cust_id, fed_id
    FROM customer
    WHERE cust_id = 'I'
    AND fed_id BETWEEN 5000-00-000 AND 9999-999-000;
    2. A.
    Yes
    B.
    No
    C.
    Range too high to compare
    D.
    None of the mentioned

    View Answer

    Workspace

    View Answer

    Answer : Option B

    Explanation :

    In the following query, there will be no error in executing as 5000-00-000 AND 9999-999-000 is "string ranges.

Write your comments here:

Be The First To Comment