DML_SELECT_STATEMENT.sql

-- DATA MANIPULATION LANGUAGE
-- SELECT STATEMENT
-- SELECT SELECT_LIST FROM SOURCE_LIST WHERE ORDER BY HAVING;

-- EMPLOYEES TABLOSUNDAKİ TÜM VERİLERİ LİSTELEMEK.
SELECT * FROM EMPLOYEES;

-- EMPLOYEES TABLOSUNDAN SADECE FIRST NAME, LAST NAME VE E MAIL KOLANLARINI LİSTELEMEK.
SELECT FIRST_NAME, LAST_NAME, EMAIL FROM EMPLOYEES;

-- EMPLOYEES TABLOSUNDAKİ MANGER ID KOLONUNU EKRANA YAZDIRIRKEN KOLON ADINI "M", FIRST NAME KOLONUNU İSE "ADI" OLARAK YAZDIRSIN.
SELECT MANAGER_ID M, FIRST_NAME ADI FROM EMPLOYEES;

-- EMPLOYEES TABLOSUNDAKİ FIRST NAME VE EMAIL KOLONLARININ İSİMLERİNİ SIRAYIYLA "ILK ADI", "E POSTA" OLARAK EKRANA YAZDIRSIN.
SELECT FİRST_NAME "ILK ADI", EMAIL "E POSTA" FROM EMPLOYEES;

-- 90 NOLU DEPARTMANDA BULUNANLARI LİSTELESİN.
SELECT * FROM EMPLOYEES WHERE DEPARTMENT_ID = 90;

-- 90 VEYA 100 NOLU DEPARTMANDA BULUNANLARI LİSTELESİN.
SELECT * FROM EMPLOYEES WHERE DEPARMENT_ID IN (90,100);
SELECT * FROM EMPLOYEES WHERE DEPARTMENT_IS = 90 OR DEPARTMENT_ID = 100;

-- LAST NAME'İN BAŞINDA M HARFİ BULUNANLARI LİSTELESİN.
SELECT * FROM EMPLOYEES WHERE LAST_NAME LIKE 'M%';

-- LAST NAME'IN ORTASINDA M HARFİ GEÇENLERİ LİSTELESİN.
SELECT * FROM EMPLOYEES WHERE LAST_NAME LIKE '%M%';

-- LAST NAME'İN İKİNCİ KARAKTERİ A VE DÖRDÜNCÜ KARAKTERİ E OLANLARI LİSTELESİN.
SELECT * FROM EMPLOYEES WHERE LAST_NAME LIKE '_A_E%';

-- MAAŞI 1000'DEN BÜYÜK OLANLARI VE KOMİSYON ORANLARI BOŞ OLMAYANLARI LİSTELESİN.
SELECT * FROM EMPLOYEES WHERE SALARY > 1000 AND COMISSION IS NOT NULL;

-- DEPARTMENT_ID KOLONUNA GÖRE SIRALASIN.
SELECT * FROM EMPLOYEES ORDER BY DEPARTMENT_ID;

-- DEPARTMENT_ID KOLONUNA GÖRE AZALAN, MAAŞ KOLONUNA GÖRE ARTAN BİÇİMDE SIRALASIN.
SELECT * FROM EMPLOYEES ORDER BY DEPARTMENT_ID DESC, SALARY ASC;

-- FIRST_NAME KOLONUNA GÖRE ARTAN, LAST_NAME KOLONUNA GÖRE AZALAN BİÇİMDE SIRALASIN.
SELECT FIRST_NAME, LAST_NAME FROM EMPLOYEES ORDER BY 1 ASC, 2 DESC;

-- DEPARTMENT_ID'Sİ 90 OLANLARI MAAŞINA GÖRE AZALAN BİÇİMDE SIRALASIN.
SELECT * FROM EMPLOYEES WHERE DEPARTMENT_ID = 90 ORDER BY SALARY DESC;