Home / CSE / SQL Basics :: Discussion

Discussion :: SQL Basics

  1. Find the name of cities with all entries whose temperature is in the range of 71 and 89

  2. A.

     SELECT * FROM weather WHERE temperature NOT IN (71 to 89);

    B.

     SELECT * FROM weather WHERE temperature NOT IN (71 and 89);

    C.

     SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89;

    D.

     SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;

    View Answer

    Workspace

    Answer : Option D

    Explanation :

    Explanation Not Provided


Be The First To Comment