SensiZOlmuyoR.org  
Geri git   SensiZOlmuyoR.org > İnternet - Bilgisayar > Programlama > Delphi
SQL Hakkında SQL Hakkında
Kayıt ol Yardım Üye Listesi Takvim Oyunlar Gruplar Etiketler Arama Bugünki Mesajlar Bütün Forumları okunmuş kabul et

 
Ücretsiz Siteye Üye Olmak için Tıklayın !!

SensizOlmuyor.oRg Ailesi olarak dosya ve resim uploadlarınız için www.upload.gen.tr sitesini öneriyoruz!
Cevapla
 
LinkBack Konu Araçları Stil
Eski 28-01-2008, 12:29   #1 (permalink)
Banlandı
 
*MeLeK* - ait Kullanıcı Resmi (Avatar)
 
Üyelik tarihi: 22-11-2007
Nerden: napıcan ziyaretemi geLcen!!
Mesajlar: 4.542
Konular: 2724
Üye No: 11416
Ruh halim:
Rep Gücü : 0
Rep Puanı : 4991
Rep Seviyesi : *MeLeK* has a reputation beyond repute*MeLeK* has a reputation beyond repute*MeLeK* has a reputation beyond repute*MeLeK* has a reputation beyond repute*MeLeK* has a reputation beyond repute*MeLeK* has a reputation beyond repute*MeLeK* has a reputation beyond repute*MeLeK* has a reputation beyond repute*MeLeK* has a reputation beyond repute*MeLeK* has a reputation beyond repute*MeLeK* has a reputation beyond repute


yasaksiz youtube
Standart SQL Hakkında

SELECT column1 FROM Table1 WHERE column1 = 77

SELECT <select list>WHERE <search conditions>FROM <Table list>
GROUP BY <grouping columns>HAVING <conditions>ORDER BY <sorting columns>

SELECT column1, column2 FROM Table1 WHERE indexed_column = <literal>

UPDATE Table1 SET column1 = 5 WHERE column2 > 400

SELECT * FROM Table1
WHERE column1 = 5
AND column2 = 77.3
AND column3 = 'Smith'
AND column4 < 117
AND column4 > column5

IF
(A <comparison operator> B) IS TRUE AND (B <comparison operator> C) IS TRUE
THEN
(A <comparison operator> C) IS TRUE AND NOT (A <comparison operator> C) IS FALSE

SELECT * FROM Table1
WHERE column1 = 5 AND
NOT (column3 = 7 OR column1 = column2)

SELECT * FROM Table1
WHERE column1 = 5
AND column3 <> 7
AND column2 <> 5

SELECT * FROM Table1
WHERE date_column = CURRENT_DATE
AND amount * 5 > 100.00

SELECT * FROM Table1
WHERE date_column = DATE '2002-01-01'
AND amount * 5 > 100.00

SELECT * FROM Table1
WHERE 0 = 1
AND column1 = 'I hope we never execute this'

SELECT * FROM Table1
WHERE indexed_column > 0

... WHERE column2 = 'B' AND column1 = 'A'

... WHERE column1 = 'A' OR column2 = 'B'

... WHERE column1 = 1 OR column1 = 2 OR column2 = 3

SELECT * FROM Table1
WHERE (column1 = 1 AND column2 = 'A')
OR (column1 = 1 AND column2 = 'B')

SELECT * FROM Table1
WHERE column1 = 1
AND (column2 = 'A' OR column2 = 'B')

A AND (B OR C)

(A AND B) OR (A AND C)

... WHERE NOT (column1 > 5)

... WHERE column1 <= 5

NOT (A AND B) = (NOT A) OR (NOT B)

NOT (A OR B) = (NOT A) AND (NOT B)

... WHERE NOT (column1 > 5 OR column2 = 7)

... WHERE column1 <= 5 AND column2 <> 7

... WHERE bloodtype < 'O' OR bloodtype > 'O'

... WHERE column1 = 5 OR column1 = 6

... WHERE column1 IN (5, 6)

... WHERE column1 IN (1, 3, 4, 5)

... WHERE column1 BETWEEN 1 AND 5 AND column1 <> 2

... WHERE column1 LIKE 'C_F%'

... WHERE column1 LIKE 'C_F%'

... WHERE column1 >= 'C'
AND column1 < 'D'
AND column1 LIKE 'C_F%'

... WHERE SUBSTRING(column1 FROM 1 FOR 1) = 'F'
OR SUBSTRING(column1 FROM 2 FOR 1) = 'F'
OR SUBSTRING(column1 FROM 3 FOR 1) = 'F'

... WHERE column1 SIMILAR TO '[A-F][AEK]_'

... WHERE column1 SIMILAR TO '[ABK]'

SELECT * FROM Table1
WHERE column1 = 5
UNION
SELECT * FROM Table1
WHERE column2 = 5

SELECT DISTINCT * FROM Table1
WHERE column1 = 5
OR column2 = 5

SELECT * FROM Table1
WHERE column1 = 7 AND
NOT column2 = 8

SELECT * FROM Table1
WHERE column1 = 7
EXCEPT
SELECT * FROM Table1
WHERE column2 = 8

... WHERE slow_function(column1) = 3
OR slow_function(column1) = 5

... WHERE 1 =
CASE slow_function(column1)
WHEN 3 THEN 1
WHEN 5 THEN 1
END

SELECT column1*4 FROM Table1 WHERE COLUMN1 = COLUMN2 + 7

select Column1 * 4 FROM Table1 WHERE column1=(column2 + 7)

SELECT column1 * 4 FROM Table1 WHERE column1 = column2 + 7

SELECT column1 * 4 FROM Table1 WHERE column1 = column2 + 7

... WHERE MOD(decimal_column, 1) = 0

... WHERE CAST(decimal_column AS CHAR(7)) LIKE '%.00%'

... WHERE decimal_column = CAST(decimal_column AS INTEGER)

SELECT * FROM Table1 ORDER BY column1

SELECT * FROM Table1 ORDER BY column1

SELECT * FROM Table1 ORDER BY column1, column2

SELECT * FROM Table1 ORDER BY column1, column2, column3

SELECT * FROM Table1 ORDER BY column1

SELECT column1 FROM Table1
ORDER BY column1

SELECT column1 FROM Table1 ORDER BY column2

SELECT column1 FROM Table1 ORDER BY <function>(column1)

SELECT column1 FROM Table1 WHERE column1 > -32768

SELECT DISTINCT column1 FROM Table1

SELECT * FROM Table1
RDER BY german_column COLLATE German

SELECT column1 FROM Table1
GROUP BY column1

SELECT COUNT(*) FROM Table1
HAVING COUNT(*) = 5

SELECT column1 FROM Table1
GROUP BY column1,column2 COLLATE SQL_Latin1_General

SELECT LOWER(column1) FROM Table1
GROUP BY LOWER(column1)

SELECT column1, column2 FROM Table1
GROUP BY CUBE (column1, column2)

SELECT AVG(column1), STDEV(column1), UDF1(column1)
FROM Table1
WHERE column1 > 55
GROUP BY column1
ORDER BY column1

SELECT column1, MIN(column2) FROM Table1
GROUP BY column1

SELECT UPPER(column1) FROM Table1
GROUP BY UPPER(column1)

CREATE VIEW View1 AS
SELECT column1, COUNT(column1) FROM Table1
GROUP BY column1

SELECT column1, MIN(column2) FROM Table1
GROUP BY column1 COLLATE SQL_Latin1_General

SELECT column1, column2 FROM Table1
GROUP BY CUBE (column1, column2)

SELECT secondary_key_column, primary_key_column, COUNT(*)
FROM Table1
GROUP BY secondary_key_column, primary_key_column

SELECT MIN(secondary_key_column), primary_key_column, COUNT(*)
FROM Table1
GROUP BY primary_key_column

SELECT SUM(Table1.column2), SUM(Table2.column2)
FROM Table1 INNER JOIN Table2
ON Table1.column1 = Table2.column1
GROUP BY Table1.column1

SELECT column1, SUM(column2), 0
FROM Table1
GROUP BY column1
INTERSECT
SELECT column1, 0, SUM(column2)
FROM Table2
GROUP BY column1

SELECT COUNT(*) FROM Table1, Table2
WHERE Table1.column1 = Table2.column1

SELECT COUNT(*) FROM Table2
WHERE Table2.column1 IN
(SELECT Table1.column1 FROM Table1)

SELECT column1 FROM Table1
WHERE column2 = 5
GROUP BY column1
HAVING column1 > 6

SELECT column1 FROM Table1
WHERE column2 = 5
AND column1 > 6
GROUP BY column1

SELECT column1
FROM Table1
GROUP BY column1

SELECT DISTINCT column1
FROM Table1

SELECT * FROM Table1
GROUP BY column1, column2
ORDER BY column1

SELECT * FROM Table1
GROUP BY column1, column2
ORDER BY column1, column2

SELECT column1 FROM Table1
WHERE column2 = 55
GROUP BY column1

SELECT column1 FROM Table1
GROUP BY column1

SELECT MIN(column1) FROM Table1

SELECT MIN(column1), MAX(column1)
FROM Table1

SELECT MIN(column1) FROM Table1

SELECT MAX(column1) FROM Table1

SELECT COUNT(*) FROM Table1

SELECT SUM(column1) FROM Table1 WHERE column1 > 5

SELECT COUNT(*) FROM Table1

SELECT COUNT(DISTINCT column1)
FROM Table1
WHERE column2 > 55

SELECT COUNT(*) FROM Table1

SELECT COUNT(1) FROM Table1

SELECT SUM(1) FROM Table1

SELECT CAST(SUM(column1) AS DECIMAL(10))
FROM Table1

SELECT SUM(CAST(column1 AS DECIMAL(10)))
FROM Table1

SELECT SUM(CAST(column1 AS BIGINT))
FROM Table1

SELECT column1 AS col1, SUM(column2)
FROM Table1
WHERE column1 IS NOT NULL
GROUP BY column1
UNION ALL
SELECT 'Total' AS col1, SUM(column2)
FROM Table1
ORDER BY col1

SELECT MAX(LOWER(column1)) FROM Table1
GROUP BY column1

SELECT LOWER(column1) FROM Table1
GROUP BY LOWER(column1)

SELECT column1 FROM Table1
GROUP BY column1 COLLATE SQL_Latin1_General

SELECT LOWER(column1) AS alias_name
FROM Table1
GROUP BY alias_name
ORDER BY alias_name

SELECT MIN(column1)
FROM Table1

SELECT MIN(UPPER(column1))
FROM Table1

SELECT * FROM Table1, Table2
WHERE Table1.column1 = Table2.column1
AND Table1.column2 = Table2.column2

SELECT * FROM Table1, Table2
WHERE Table1.column1 = Table2.column1
AND Table1.column1 = 55

SELECT * FROM Table1, Table2
WHERE Table1.column1 = 55
AND Table2.column1 = 55

SELECT * FROM Table1, Table2, Table3
WHERE Table1.column1 = Table2.column1
AND Table2.column1 = Table3.column1

SELECT * FROM Table1, Table2, Table3
WHERE Table1.column1 = Table2.column1
AND Table2.column1 = Table3.column1
AND Table1.column1 = Table3.column1

SELECT Table1.column1, Table2.column1
FROM Table1 LEFT JOIN Table2
ON Table1.column1 = Table2.column1

SELECT MIN(Table1.column1)
FROM Table1, Table2
WHERE Table1.column1 = Table2.column1

SELECT * FROM Table1
WHERE Table1.column1 IN
(SELECT Table2.column1
FROM Table2
WHERE Table2.column1 = 5)

SELECT Table1.*
FROM Table1, Table2
WHERE Table1.column1 = Table2.column1
AND Table2.column1 = 5

SELECT Table1.column1 FROM Table1
WHERE Table1.column1 NOT IN
(SELECT Table2.column1 FROM Table2)

SELECT Table1.column1
FROM Table1 LEFT JOIN Table2
ON Table1.column1 = Table2.column1
WHERE Table2.column1 IS NULL

SELECT * from Table1
WHERE Table1.column1 IN
(SELECT Table2.column1 FROM Table2
WHERE Table2.column1 = 5)

SELECT * from Table1
WHERE Table1.column1 IN
(SELECT DISTINCT Table2.column1 FROM Table2
WHERE Table2.column1 = 5)

SELECT * FROM Table1
WHERE EXISTS
(SELECT column1 FROM Table2)

SELECT * FROM Table1
WHERE Table1.column1 IN
(SELECT Table2.column1 FROM Table2)

SELECT * FROM Table1
WHERE EXISTS
(SELECT * FROM Table2
WHERE Table1.column1 = Table2.column1)

SELECT * FROM Table1
WHERE EXISTS
(SELECT * FROM Table2
WHERE Table1.column1 = Table2.column1
UNION
SELECT * FROM Table3
WHERE Table1.column2 = Table3.column1)

SELECT * FROM Table1
WHERE Table1.column1 IN
(SELECT Table2.column1 FROM Table2)
OR Table1.column2 IN
(SELECT Table3.column1 FROM Table3)

SELECT * FROM Table1
WHERE column1 > ALL
(SELECT column1 FROM Table2)

SELECT * FROM Table1
WHERE column1 > ANY
(SELECT MAX(column1) FROM Table2)

SELECT column1 FROM Table1
WHERE Table1.column2 NOT IN
(SELECT column2 FROM Table2)

SELECT column1 FROM Table1
EXCEPT
SELECT column1 FROM Table1
WHERE Table1.column2 IN
(SELECT column2 FROM Table2)

SELECT column1 FROM Table1
WHERE ROWID = '00001F20.00A3.0001'
FOR UPDATE OF column1
*MeLeK* isimli üyemiz çevrimdışıdır. (Offline)  
Bu Mesajı Google'a Ekle!Bu Mesajı FaceBook'da Paylaş!
Alıntı ile Cevapla
Cevapla

Bu konunun kısa yolunu aşağıdaki sitelere ekleyebilirsiniz!

« önceki Konu | sonraki Konu »

Konu Araçları
Stil
Normal Normal

Yetkileriniz
Konu Açma Yetkiniz Yok
Mesaj Yazma Yetkiniz Yok
Eklenti Yükleme Yetkiniz Yok
Mesajınızı Değiştirme Yetkiniz Yok
BB code is Açık
Smileler Açık
[IMG] Kodları Açık
HTML-KodlarıKapalı
Trackbacks are Açık
Pingbacks are Açık
Refbacks are Açık


Tüm Saatler GMT +3. Şuan Saat: 03:47 .
(Türkiye için GMT +2 seçilmelidir.)

İletişim - SensiZOlmuyoR.org - Arşiv - Yukarı git

Powered by vBulletin Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
www.SensiZOlmuyoR.org © 2007 - 2008


* Metin2 * Trendy Bayan