(Free Practice With Testbook Mock TestsAE & JE Electrical Engg. Exams Previous Year Papers Mock Test (80+ Papers)132 Total Tests | 8 Free TestsUPRVUNL JE Mechanical 2021 Mock Test36 Total Tests | 2 Free TestsOptions: more than the maximum value in the subquery less than the minimum value in the subquery is equivalent to IN none of the options Correct Answer: Option 2 (Solution Below)This question was previously asked inNIELIT Scientific Assistant A Official Paper 2020Attempt Online ››Solution: Download Question With Solution PDF ››The ALL operator returns true if all of the subquery values meet the conditionSyntaxSELECT column_name(s)FROM table_nameWHERE column_name operator ALL(SELECT column_name FROM table_name WHERE condition);The operator we can use must be a standard comparison operator (=, <>, !=, >, >=, <, or <=).Therefore the Option 2 will be correct i.e, Less than the minimum value in the subqueryDownload Question With Solution PDF ››

• A. more than the maximum value in the subquery
• B. less than the minimum value in the subquery
• C. is equivalent to IN
• D. none of the options