SELECT MAX(HIRE_DATE) AS İLKGİRİS, MIN(HIRE_DATE) AS SONGİRİS — İŞE İLK GİRİŞ VE SON GİRİŞ TARİHİNİ GETİRME FROM EMPLOYEES SELECT COUNT (*) FROM EMPLOYEES WHERE DEPARTMENT_ID=22 — SATIRLARI SAYAR SELECT COUNT (DISTINCT DEPARTMENT_ID) FROM EMPLOYEES — KAC FARKLI KATEGORİYE KAYITLI ELEMN VAR SELECT AVG(COMMISSION_PCT) FROM EMPLOYEES — ORTALAMA ALIR SELECT DISTINCT DEPARTMENT_ID, AVG(SALARY) FROM EMPLOYEES GROUP […]

    SELECT CASE SIGN (-125) WHEN 1 THEN ‘POZİTİF’ — KOSUL SAĞLANIRSA POZİTİF WHEN 0 THEN ‘NEGATİF’– KOSUL SAĞLANIRSA NEGATİF ELSE ‘BOS’ END — KOSUL SAĞLANMIYORSA BOS YAZDUR SELECT LAST_NAME,SALARY,JOB_ID, CASE JOB_ID — BİR ÖRNEK WHEN ‘AD_PRES’ THEN 1.5*SALARY– AD PRES YAZANLARA BİRBUCUK KAT ZAM YAP ELSE SALARY END FROM EMPLOYEES

use HR –CAST FONKSİYONU– SELECT LAST_NAME, DATEDIFF(YEAR, HIRE_DATE,GETDATE()) AS WEEKS — TARİH ARALIĞINDAKİLERİ GETİR FROM EMPLOYEES WHERE DEPARTMENT_ID=90 SELECT CONVERT (INT,(CONVERT(FLOAT, ‘6.7’,0))) — DÖNÜŞTÜRÜR SELECT LAST_NAME, UPPER(CONCAT(SUBSTRING (LAST_NAME,1,8),’_US’)) FROM EMPLOYEES WHERE DEPARTMENT_ID=60– AL BUYUT EKLE SELECT LAST_NAME,FIRST_NAME, ISNULL(CONVERT(NVARCHAR,COMMISSION_PCT),’BOS’) FROM EMPLOYEES — NULL OLANLARI BOS İLE DĞEİŞTİR KOMUTU

use HR select ROUND (3.44,5)– yuvarlama yapar select ABS (-1234)– mutlak değer alır select POWER (3,4)– ÜST değer alır select avg (salary) as ortalama from EMPLOYEES– tüm satırları toplayıp satır sayısına böler select max (salary) as ortalama from EMPLOYEES — en yuksek bir tanesini getirir select min (salary) as ortalama from EMPLOYEES — en düşük […]

SQL LOWER UPPER , LEN , CHARINDEX, REPLACE, TRIM FONSİYONLARI ORNELKERİ SELECT SUBSTRING (LAST_NAME,3,5) FROM EMPLOYEES — SUBSTRING 3, KARAKTER DEN BASLAYIP 5 KARAKTER GETİR WHERE LOWER (LAST_NAME) LIKE ‘__k%’ –LOWER FONKSİYONU TÜM KARAKTERİ KÜCÜLTÜR SELECT SUBSTRING (‘MERHABA DUNYA’,9,3) — LEN FONKDİYONU SELECT LEN (LAST_NAME) FROM EMPLOYEES — LEN KAC KARAKTER OLDUĞUNU SAYAR –CHARINDEX FPNSİYONU […]

SQL DE BİRLEŞTİRME YAPMAK İÇİN KOLONLR İÇİN CONCAT KULLANILABİLİR ASAĞIDA ÖRNEKTE GÖREBİLRİSİNİZ SELECT CONCAT (LAST_NAME,JOB_ID,’ MESLESĞİ’, JOB_ID) FROM EMPLOYEES — CONCAT BİRLEŞTİRME İŞLEMİ YAPAR WHERE LOWER (LAST_NAME) LIKE ‘__k%’ –LOWER FONKSİYONU TÜM KARAKTERİ KÜCÜLTÜR  

LOWER VE UPPER  KOMUT ÖRNEKLERİ SELECT FIRST_NAME, LOWER (LAST_NAME), JOB_ID FROM EMPLOYEES WHERE LOWER (LAST_NAME) LIKE ‘__k%’ –LOWER FONKSİYONU TÜM KARAKTERİ KÜCÜLTÜR SELECT FIRST_NAME, UPPER (LAST_NAME), JOB_ID FROM EMPLOYEES WHERE UPPER (LAST_NAME) LIKE ‘__k%’ –UPPER FONKSİYONU TÜM KARAKTERİ BÜYÜTÜR

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 […]