Which operator compares if the left value is greater than or equal to the right?

Study for the SQL Basics Test. Improve your knowledge with multiple choice questions and detailed explanations. Prepare effectively to master SQL concepts!

Multiple Choice

Which operator compares if the left value is greater than or equal to the right?

Explanation:
Comparison operators let you compare two values, and the greater-than-or-equal-to operator checks whether the left value is greater than or equal to the right. It uses the symbol >= and is true when the left value is larger than the right or exactly the same. For example, 7 >= 5 is true, and 5 >= 5 is true, while 4 >= 5 is false. This differs from the other operators: > requires strictly greater, < is the opposite direction, and <= includes equality but not a strictly greater value. In SQL, you’d use this in conditions like WHERE or HAVING to filter rows where one value is at least another.

Comparison operators let you compare two values, and the greater-than-or-equal-to operator checks whether the left value is greater than or equal to the right. It uses the symbol >= and is true when the left value is larger than the right or exactly the same. For example, 7 >= 5 is true, and 5 >= 5 is true, while 4 >= 5 is false. This differs from the other operators: > requires strictly greater, < is the opposite direction, and <= includes equality but not a strictly greater value. In SQL, you’d use this in conditions like WHERE or HAVING to filter rows where one value is at least another.

More practice questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy