Q&A
| Q1: | Can I have more than one AND in the WHERE clause? |
| A1: | Yes. In fact, all the operators can be used multiple times. An example would be
SELECT SALARY FROM EMPLOYEE_PAY_TBL WHERE SALARY > 20000 AND BONUS BETWEEN 1000 AND 3000 AND POSITION = 'VICE PRESIDENT' |
| Q2: | What happens if I use single quotation marks around a NUMBER datatype in a WHERE clause? |
| A2: | Your query still processes. Quotation marks are not necessary for NUMBER fields. |
Get Sams Teach Yourself SQL in 24 Hours, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
