use HR SELECT EMPLOYEE_ID,LAST_NAME,JOB_ID,SALARY FROM EMPLOYEES WHERE SALARY>=10000 AND JOB_ID LIKE ‘%MAN%’ — AND İLE TÜM KOSULLAR SAĞLANIRSA GELİR– SELECT EMPLOYEE_ID,LAST_NAME,JOB_ID,SALARY FROM EMPLOYEES WHERE SALARY>=10000 OR JOB_ID LIKE ‘%MAN%’ — OR İLE KOŞULUN HERHANGİ BİRTANESİ SAĞLANIRSA GETİRİR– SELECT EMPLOYEE_ID,LAST_NAME,JOB_ID,SALARY FROM EMPLOYEES WHERE JOB_ID NOT IN ( ‘SA_REP’ )– IN KOMUTU İLE KOŞUL SAĞLANIRSA GETİRİR– SELECT […]

use HR SELECT EMPLOYEE_ID,LAST_NAME,JOB_ID,SALARY FROM EMPLOYEES WHERE SALARY>=10000 AND JOB_ID LIKE ‘%MAN%’ — AND İLE TÜM KOSULLAR SAĞLANIRSA GELİR– SELECT EMPLOYEE_ID,LAST_NAME,JOB_ID,SALARY FROM EMPLOYEES WHERE SALARY>=10000 OR JOB_ID LIKE ‘%MAN%’ — OR İLE KOŞULUN HERHANGİ BİRTANESİ SAĞLANIRSA GETİRİR–

use HR –VERİTABANIMIZA BAĞLANDIK– SELECT –GETİR DEMEK– DEPARTMENT_ID,DEPARTMENT_NAME –TABLODAKİ KOLONLAR– FROM –HANGİ TABLODAN GETİRELİM- DEPARTMENTS GO –SORGUNUN BİTTİĞİNİ GÖSTERİR– SELECT * FROM JOBS SELECT LAST_NAME AS –GÖRÜNEN İSMİNİ DEĞİŞTİR– SOYADİ ,SALARY ,COMMISSION_PCT,SALARY*COMMISSION_PCT FROM EMPLOYEES “NULL” SELECT FIRST_NAME,LAST_NAME,FIRST_NAME+ ‘ HASAN AYLAS ‘+ LAST_NAME AS “SOYADİ” FROM EMPLOYEES SELECT DISTINCT –TEKRARLI KOMUTLARI YOKET- DEPARTMENT_ID FROM EMPLOYEES EXECUTE […]