Database Reference
In-Depth Information
Example:
SELECT sal
FROM emp
WHERE ename LIKE 'SM%';
The output will be only those salaries from emp table where
ename begins with “SM”. Another variation of above query is as
follows.
ename LIKE 'SMITH_'
The output will be only those records where ename begins with
“SMITH” and there should not be more than one character after
it. That one character can be any alphanumeric literal.
Example:
SELECT ename, deptno
FROM emp
WHERE comm IS NULL;
The output will be ename and deptno but only those records
where comm field has NULL value. NULL is a special value and
just keep in mind that its not Zero. It can be visualized as empty
field occupying zero byte.
Search WWH ::




Custom Search