Logical Operators - AND Operator

Logical Operators that can be used in SQL sentence are:

AND Operator: Oracle engine will process all rows in a table and display the result only when all of the conditions specified using and AND operator are satisfied.

Example: Retrieve the contents of the columns product_no,description,profit_percent,sell_price from the table product_master where the values contained in the field profit_percent is between 10 and 20 both inclusive.

SELECT product_no,description,profit_percent,sell_price From product_master Where profit_percent >=10 AND profit_percent <= 20;

No comments: