Yavuz Kara

AS:yeni ad tanimlar
Select veritabanindaki ad AS istedigin ad from kisiler
-------
ORDER BY:listeyi siralar DESC azalan,ASC artan
Select *from kisiler ORDER BY soyad DESC
-------
DISTINCT:tekrarlanan satirlari gostermez
Select DISTINCT adi from kisiler
-------
Sabit Metin:
Select "{"+TEL+"}" from kisiler
-------
Yas Hesabi:
Select Kullanici_ID DATEDIFF(yy,dogumTarihi,GETDATE()) AS Yas from kisiler
-------
TOP:kac tane verinin cekileceigini sinirlandirir.
Select TOP 10 adi from kisiler
Select TOP 20 PERCENT adi from kisiler
-------
WHERE:kisitlama icin kullanilir
Select adi from kisiler WHERE yas >25
-------
LIKE:
Select adi from kisiler WHERE adi LIKE 'A%'
Select adi from kisiler WHERE adi LIKE 'A___'
LIKE '[^AE]%' bas harfi A veya E olmayan
LIKE 'A[nm]%' bas harfi A olup ikinci harfi n yada m olan
-------
OR:veya baglaci
Select adi from kisiler WHERE adi='Ali' OR soyad='limandal'
AND:ve baglaci
-------
IN:OR un yerine kullanilir cok oldugu durumlarda
Select * from kisiler WHERE dogumyeri IN ('Trabzon','Vakfikebir','carsibasi')
-------
BETWEEN: arasinda ifadesi
Select * from kisiler WHERE yas BETWEEN 25 AND 50
-------
WHERE IS NULL:bos olanlari listelemek
WHERE IS NOT NULL:bos olmayanlari listelemek

Count:toplam sayi bulur.
Select COUNT(*) from kisiler WHERE cinsiyet='K'
-------
SUM:toplar
Select SUM(Harcamalar) from gider WHERE fiyat>100
-------
MAX:en buyugu bulur
MIN:en kucugu bulur
AVG:ortalama bulur
Select MAX(harcama) from giderler
-------
GROUP BY: gruplar
Select Urun_ID ,SUM(adet) from urunler GROUP by Urun_ID
-------
HAVING:where in group by ile kullanilis sekli
Select Urun_ID,SUM(Adet) from urunler GROUP by Urun_ID HAVING SUM(Adet)>100
------
JOIN
Inner Join:Ayni degere sahip kolonlari birlestirir.
Select C.Adi,C.Soyadi,E.adres from isciler as C INNER JOIN kisibilgileri AS E ON C.isci_ID=E.isci_ID
-------
Outer Join:Tam eslesmeyen kolonlari birlestirir.
-Left outer Join:Bir tablonun tamamini digerinin eslesenini alip listeler.
Select R.Ad, PR.UrunId From Urunler AS R LEFT OUTER JOIN UrunDetay AS PR ON r.UrunId=PR.UrunId

-Right outer join:tam tersi
-Full outer join:eslesmeyen tüm verileri listeler.
-------
Cross Join:eslesmeye bakmaksizin tüm verileri listeler.
Self Join:tek tabloyu iki tablo gibi gosterir.
-------
INSERT:
İnsert into Kisiler (Ad,Soyad) Select FirstName,LastName From Contact --coklu toplama
-------
UPDATE:
Update Kisiler Set Ad='Veli' Where Soyad='cekic'
-------
DELETE:
Delete From Kisiler Where Soyad='cekic'
-------
TRUNCATE:
Truncate Table Kisiler--butun tabloyu siler.