Computer Science
Assertion. Both BETWEEN and IN operators can choose from a list of values.
Reason. The value ranges and a list of values are interpreted in the same way in SQL.
SQL Queries
1 Like
Answer
(c)
Assertion is true but Reason is false.
Explanation
Both BETWEEN and IN operators can select values from a list. The BETWEEN operator defines a range of values into which column values must fall to make the condition true. This range includes both lower and upper values. In contrast, the IN operator is used to specify a list of values. It selects values that match any value in the given list of values. Therefore, while both operators involve selecting values from a list, they operate differently in SQL, distinguishing between value ranges and specific value lists.
Answered By
1 Like
Related Questions
Assertion. DDL and DML are not the same.
Reason. DDL and DML are two subcategories of SQL where DDL creates the objects and DML manipulates the data.
Assertion. DDL and DML both are part of SQL.
Reason. Both DDL and DML are interchangeable.
Write a query to display EName and Sal of employees whose salary is greater than or equal to 2200 from table Empl.
Write a query to display details of employees who are not getting commission from table Empl.