IhАr U@H@GTRGFPHVUG6SDID`6aH6F 01

U@H@GÃTRGÃFPHVUG6SDIDÃ`6aH6FÃÃ
IhrÃ
Dört
NULL
øúyr
Alias
BvqryvrÃ
• Sorgulama yapmap için SELECT statemenÕÃxyyhÕyÕ
ç
ç
ç
ç SELECT clauseuna sadece görülmesi istenen columnlar ya
SELECT [DISTINCT] {* | column [alias], ...} FROM table
SELECT * FROM dept
SELECT deptno, dname, loc FROM dept
SELECT loc, dname, deptno FROM dept
SELECT deptno, loc FROM dept
SELECT ename, sal, sal + 300 FROM emp
SELECT ename, sal, 12 * sal + 100 FROM emp
SELECT ename, sal, 12 * (sal + 100) FROM emp
T@G@8UÃpyhrqhxvÃÃvúhrvÃÃpyyhÃhyhÕhÃtryv
T@G@8UÃpyhrhÃhiyrqhxvÃpyyhÕÃurvÃhÕyhivyv
T@G@8UÃpyhrhÃhiyrqhxvÃpyyhÕÃurvÃvrrÃÕhqhÃhÕyhivyv
Õyhivyv
• ASPHÃpyhrÃqÕúÕqhÃiÃpyhryhqhÃhvrvxÃvúyryrÃ-xyyhÕyhivyv
• ToyhÕÃt|rrxÃvovÃhqrprÃrxhhÃrvÃpyyhÃhoÕyÕÃUhiyrhÃhyhÃhoÕyh
• gpryvxÃÕhÕÃ-ÃyÃvúyryrÃhÕÃ|pryv÷rÃhuvrÃyqhÃh÷hÃ
• 7vÃpyÃIPUÃIVGGÃhqhÃQvhÃFrÃyhhxÃhhÕyhqÕhÃIVGGÃqr÷rÃ
içerebilir
• IVGGÃhhhÕúÃivyvrrÃivÃqr÷rqvÃIVGG13ÃIVGG13¶¶ÃIVGG13¶Ãµ
• IVGGÃqr÷ryvÃivÃhvrvxÃvúyrvÃpÃIVGGÃy
• 7vÃpyÃvvvÃrxhqhÃshxyÕÃvvyrÃt|rrÃyhÕhÃhyvhÃhÕyhhÃqrv
• 8yyhÕÃihúxhÃpyyhyhhvrvxÃvúyryryrÃrhÃhivÃqr÷ryryrÃivyrúvv
• T@G@8UÃpyhrqhÃpyyhÕÃivyrúvvvÃxyhÃhyhúÕyhÕÃvovÃxyyhÕyhÃ
SELECT ename, sal, 12 * sal + comm FROM emp
SELECT ename Name, job, sal “Annual Salary $” FROM emp
Column
7vyrú
SELECT ename||’ is a ‘||job||’ and will earn ‘|| sal * 12 || ’ $ in year ’||2000 Employee FROM emp
xhhxryrÃqvvvrÃGvrhyÃxhhxryrÃqrvÃUhvuÃxhhxryrÃµ¶ÃvovrÃhyÕhyÕÃ
tirmek
hÕyhÃvrÃyq÷ÃtvivÃhÕyhyÕqÕ
Unique
pyyhÕÃivyrúvvvÃvrÃqr÷ryrvvÃt|rv
96U6`DÃTDIDSG6I9DSH6FÃW@ÃTDS6G6H6FÃÃ
IhrÃ
Where
• SELECT claurqhxvÃ9DTUDI8UÃxrÃqÃxrqvvqrÃhÃhÕyhÃ
SELECT DISTINCT deptno FROM emp
SELECT DISTINCT deptno, job FROM emp
BvqryvrÃ
• WHERE clarÃq|qyrprxÃÃhÕÕÃÕÕyhqÕÕyÕ
SELECT [DISTINCT] {* | column [alias], ...} FROM table [WHERE condition(s)]
ç
ç Hiredate’i 01-JANç
ç
anlar
ç
ç Mgr’si 7902, 7566 yada 7788 olanlar
ç Ename’i FORD yada ALLEN olanlar
ç
ç Hiredate’i 01-JAN-81 ile 31-DECç Ename’inin ikinci harfi A olanlar
ç Comm’u NULL olanlar
ç Gerçek % vaya _ karakterlerini kullanmak içi
ç Sal’i 1100’den büyük ve job
ç
ç
ç
ç
ç Ename’inde A harfi olmayanlar
ç Comm’u NULL olmayanlar
@hr¶vÃE6H@TÃyhyhÃµ¶ÃvovrÃhÕyÕÃÃphrÃrrvrqv
Logical
Operators
SELECT * FROM emp WHERE ename = ‘JAMES’
SELECT * FROM emp WHERE hiredate = ’01-JAN-95’
SELECT * FROM emp WHERE deptno = 10
SELECT * FROM emp WHERE sal <= comm
SELECT * FROM emp WHERE sal BETWEEN 1000 AND 1500
SELECT * FROM emp WHERE mgr IN (7902, 7566, 7788)
SELECT * FROM emp WHERE ename IN (‘FORD’, ‘ALLEN’)
SELECT * FROM emp WHERE ename LIKE ‘S%’
SELECT * FROM emp WHERE hiredate LIKE ‘%81’
SELECT * FROM emp WHERE ename LIKE ‘_A%’
SELECT * FROM emp WHERE comm IS NULL
SELECT * FROM emp WHERE ename LIKE ‘\%A\_\%B’ ESCAPE ‘\’
ODD
ÕU6
TRUE
T
F
U
FALSE
F
F
F
UNKNOWN
U
F
U
ÃvryÃ
$ÃhhÕqhÃy
@hr¶vÃTÃuhsvÃvyrÃihúyhhyh
'
PSÃ
TRUE
FALSE
UNKNOWN
ÃhhÕqhÃyhyh
Ã@T86Q@Ãµ¶ÃxyyhÕyÕ
¶ÕÃ8G@SFÃyhyh
Thy¶vÃ
¶qrÃixÃrhÃwi¶ÕÃ8G@SFÃyhyh
Ei¶ÕÃ8G@SFÃH6I6B@SÃ6I6G`TUÃyhhyh
Ei¶ÕÃ8G@SFÃH6I6B@SÃ6I6G`TUÃyhhyh
Thy¶vÃ
ç
ç
ç
ç
SELECT * FROM emp ORDER BY hiredate
SELECT * FROM emp ORDER BY hiredate DESC
SELECT ename, sal * 12 annsal FROM emp ORDER BY annsal
SELECT ename, sal, job FROM emp ORDER BY deptno, sal DESC, job
6I9Ã
ÃyhyhÃThÕyhÃyq÷ÃtvivÃhÕyÕ
Thy¶vÃp¶qhÃxoxÃrhÃrúvÃyhyh
Thy¶vÃ
SELECT * FROM emp WHERE sal >= 1100 AND job = ‘CLERK’
SELECT * FROM emp WHERE sal >= 1100 OR job = ‘CLERK’
SELECT * FROM emp WHERE job NOT IN (‘CLERK’, ‘MANAGER’, ‘ANALYST’)
SELECT * FROM emp WHERE NOT job IN (‘CLERK’, ‘MANAGER’, ‘ANALYST’)
SELECT * FROM emp WHERE sal NOT BETWEEN 1000 AND 1500
SELECT * FROM emp WHERE ename NOT LIKE ‘%A%’
SELECT * FROM emp WHERE comm IS NOT NULL
SELECT * FROM emp WHERE job = ‘SALESMAN’ OR job = ‘PRESIDENT’ AND sal > 1500
SELECT * FROM emp WHERE (job = ‘SALESMAN’ OR job = ‘PRESIDENT’) AND sal > 1500
TRUE
FALSE
UNKNOWN
-MON-YY’
($ÃyhyhÃµ¶ÃvovrÃhÕyÕÃÃ9rshyÃshÃµ99
9r¶Ã
TRUE
T
T
T
FALSE
T
F
U
ÃvyrÃ
$ÃhhÕqhÃyhhyh
1
2
3
4
5
gpryvxÃTÕhÕ
Operator
(...)
=,<>,>=,...
NOT
AND
OR
Hireqhr¶rxvÃrÃrxvÃhvurÃrÃÃhvurÃt|rÃÕyhhyhÃhh
Cvrqhr¶rxvÃrÃÃhvurÃrÃrxvÃhvurÃt|rÃÕyhhyhÃhh
6yvhyhhÃt|rÃqrÃÕhyhhÃhh
PS9@SÃ7`ÃpyhrqhxvÃivÃpyÃT@G@8UÃpyhrqhÃyhÕÃúhÃqr÷vy
UNKNOWN
T
U
U
NOT
TRUE
FALSE
UNKNOWN
F
T
U

Download Report