SQL Operator Precedence
Logical Operator has Precedence and here is the ranking:
MySQL, Oracle, SQL server, PostgreSQL:
select ISBN_no "ISBN", item_qty*PRICE "Order Sum" from order_books where Isbn_no like '%8' OR Isbn_no like '0%' AND item_qty*PRICE < 100
Find Isbn number and order total for all orders where Isbn_no ends with the letter of 8 or where Isbn number starts with the letter 8 and has an order amount less than $ 100.
The result should be:
© 2010 by Finnesand Data. All rights reserved.
This site aims to provide FREE programming training and technics.
Finnesand Data as site owner gives no warranty for the
correctness in the pages or source codes.
The risk of using this web-site pages or any program
codes from this website is entirely at the individual user.