OCA: Oracle Database 11g Administrator Certified Associate Study Guide- P3: There is high demand for professionals in the information technology (IT) industry, and Oracle certifications are the hottest credential in the database world. You have made the right decision to pursue certification, because being Oracle Database 11g certified will give you a distinct advantage in this highly competitive market. | Writing Simple Queries 31 Greater Than The operator evaluates to TRUE if the left side expression or value of the operator is greater than the right side of the operator. SELECT first_name last_name Name commission_pct FROM employees WHERE commission_pct .35 Name COMMISSION_PCT John Russell .4 Less Than or Equal to The operator evaluates to TRUE if the left side expression or value of the operator is less than or equal to the right side of the operator. SELECT first_name last_name Name commission_pct FROM employees WHERE commission_pct .15 Name COMMISSION_PCT - Oliver Tuvault .15 Danielle Greene .15 Mattea Marvins .1 David Lee .1 Sundar Ande .1 Amit Banda .1 William Smith .15 Elizabeth Bates .15 Sundita Kumar .1 Kimberely Grant .15 Charles Johnson .1 11 rows selected. Greater Than or Equal to The operator evaluates to TRUE if the left side expression or value of the operator is greater than or equal to the right side of the operator. SELECT first_name last_name Name commission_pct FROM employees WHERE commission_pct .35 32 Chapter 1 Introducing SQL Name COMMISSION_PCT John Russell Janette King Patrick Sully Allan McEwen .4 .35 .35 .35 ANY or SOME You can use the ANY or SOME operator to compare a value to each value in a list or subquery. The ANY and SOME operators always must be preceded by one of the following comparison operators or . SELECT first_name last_name Name department_id FROM employees WHERE department_id ANY 10 15 20 25 Name DEPARTMENT_ID Jennifer Whalen 10 Michael Hartstein 20 Pat Fay 20 ALL You can use the ALL operator to compare a value to every value in a list or subquery. The ALL operator must always be preceded by one of the following comparison operators or . SELECT first_name last_name Name department_id FROM employees WHERE department_id ALL 80 90 100 Name DEPARTMENT_ID Nancy Greenberg 100 Daniel Faviet 100 John Chen 100 Ismael Sciarra 100 Jose Manuel Urman 100 Luis Popp 100 Shelley Higgins 110 William Gietz 110 8 rows selected. For all the .
