Örnek Kodlar Delphi

//SEÇME
Select Alanlar From Tablo Adı
 
SELECT last_name, first_name
FROM "customer.db"
WHERE (last_name > :lname) AND (first_name < :fname)
 
//SIRALAMA (Order By)
Select Last_Name, First_Name From custoly.db
Order By first_name ASC; //a-z
 
Select Last_Name, First_Name From custoly.db
Order By first_name DESC; //z-a
 
//BİRDEB FAZLA ALAN SIRALAMA
Select Last_Name, First_Name From custoly.db
Order By Alanadı1, Alanadı2, Alanadı3 ASC; //a-z
 
 
//KOşULLU LİSTELEME ve SIRALAMA
Select * From country.db
Where Area > 100000 AND Area < 1000000
 
Select * From country.db
Where Area > 100000 AND Population < 1000000
 
//Between ile Aralık Listeleme
Select * From country.db
Where Area between 100000 AND 1000000
 
//SORGULAMA (IN Operatörü)
Select * From custoly.db
where CustNo=1 or CustNo=2
 
Select * From custoly.db
where CustNo IN(1,5,10,12,20)
 
 
//SQL BELLİ ALANLARI BOş OLAN KAYITLARI LİSTELEME
SELECT *
FROM orders
WHERE (saledate IS NULL) //boş olanlar
WHERE (saledate IS NOT NULL) //boş olmayanlar
 
//SQL TİP DEÐİşTİRME
CAST(column_reference AS data_type)
//varolan bir tipi sql ile başka bir tipe sanal olarak geçirme
SELECT CAST(TERMS AS CHAR(1))
FROM ORDERS
//üsteki örnekte alandaki sadece birinci karakterin bilgisi okutuluyor.
 
SELECT SaleDate,
  SUBSTRING(CAST(CAST(SaleDate AS DATE) AS CHAR(10)) FROM 1 FOR 1)
FROM Orders
 
//SQL TARİH İşLEMLERİ
EXTRACT(extract_field FROM column_reference)
YEAR, MONTH, DAY, HOUR, MINUTE, or SECOND
/*5 Ayları listele */
SELECT saledate, orderno
FROM orders
WHERE (EXTRACT(MONTH FROM saledate) = 5)
 
/*Verilen tarih alanını ay,yıl,gün olarak yeni alanlarla bölerek göster*/
SELECT SaleDate,
  EXTRACT(YEAR FROM saledate) AS YY,
  EXTRACT(MONTH FROM saledate) AS MM,
  EXTRACT(DAY FROM saledate) AS DD
FROM Orders
 
//SORGULAMA (LIKE)
Select * From custoly.db
where last_name LIKE '%M%' //İçimde M harfi bulunanlar
 
Select * From custoly.db
where last_name LIKE 'H%'//H harfi ile başlayanlar
 
Select * From custoly.db
where last_name LIKE '%a'//a ile bitenler
 
//SUM FONKSİYONU
Toplam Alma
Select SUM (Cost) as SONUC
From parts.db
Sonuç adında sanal alan yapılır ve Cost alanı baştan sona toplanı buraya aktarılır
 
//Aynı Anda Birden Fazla Alan Toplatılabilir
Select SUM (Cost) as SONUC1, SUM (ListPrice) as SONUC2
From parts.db
 
Select SUM (Cost * 10/100) as SONUC1, SUM (ListPrice * 10/100) as SONUC2
From parts.db
 
Select SUM (Cost + ListPrice) as SONUC
From parts.db
 
//şartlı Hesaplama
Select SUM (Cost) as SONUC
From parts.db
Where PartNo < 3000
 
//AVG Foksiyonu
Ortalama Alma
 
Select AVG (Cost) as SONUC
From parts.db
 
//MAX Fonksiyonu
Select MAX (Cost) as SONUC
From parts.db
 
//MİN Fonksiyonu
Select MIN (Cost) as SONUC
From parts.db
 
//COUNT Fonksiyonu
Tablo içinde sayma işlemi gerçekleştirir
 
Select COUNT(Cost) as SONUC
From parts.db
 
Select COUNT(*) as SONUC
From parts.db
 
şartlı Kayıt sayısı öğrenme
Select COUNT(*) as SONUC
From parts.db
Where Cost > 100
 
Varsayalım ki veri tabanında 10 tane murat var. Yukarıdaki işlemler bunları tek tek sayar bu işlemi önlemek ve muratları tek saymak içim ;
 
Select COUNT(DISTINCT Adi) as SONUC
From parts.db