QA

Team-Fly    

 
Sams Teach Yourself SQL in 24 Hours, Third Edition
By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Hour 8.  Using Operators to Categorize Data


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 data type in a WHERE clause?

A2:

Your query still processes. Quotation marks are not necessary for NUMBER fields.


Team-Fly    
Top
 


Sams Teach Yourself SQL in 24 Hours
Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)
ISBN: 0672335417
EAN: 2147483647
Year: 2002
Pages: 275

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net