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