|
IN , ALL , LIKE
IN
IN is a memebership condition used in SQL Statments.Equal to any member of test.Equivalent to "=ANY"
Syntax ::
<SELECT> * FROM <TABLE>
WHERE <COLUMN> [IN |=ANY] [(<VALUE1>,...,<VALUEX>) | (<SUBQUERY>)]
Example1 ::
SELECT * FROM CUSTOMER
WHERE CUST_SAL IN (2000,3000,4000);
|
Example 2 ::
SELECT * FROM CUSTOMER
WHERE CUST_SAL >=ANY (SELECT SAL FROm EMPLOYEE
WHERE SAL >3000);
|
ALL
ALL condition evaluates to TRUE if for all rows selected by the subquery for which the comparison holds.
Syntax ::
<SELECT> * FROM <TABLE>
WHERE <COLUMN>
<COMPARISON OPERATOR>[ALL] [(<VALUE1>,...,<VALUEX>) | (<SUBQUERY>)];
Example ::
SELECT * FROM CUSTOMER
WHERE CUST_SAL >ALL (SELECT SAL FROM EMPLOYEE);
|
LIKE
Like conditions specify a test involving pattern matching.
Syntax ::
[<SELECT>] FROM <TABLE>
WHERE <COLUMN> LIKE <PATTERN>
Example1 ::
SELECT * FROM CUSTOMER
WHERE CUST_NAME LIKE '%J' ;
|
Example2 ::
SELECT * FROM CUSTOMER
WHERE CUST_NAME LIKE '%J\_SMITH'
ESCAPE ' \' ;
|
Wildcard Mean
% matches any string of any length
_ matches any single character
|
