BoDyGuArD

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 column1column2 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_aaa_column primary_aaa_column COUNT(*)
FROM Table1
GROUP BY secondary_aaa_column primary_aaa_column

SELECT MIN(secondary_aaa_column) primary_aaa_column COUNT(*)
FROM Table1
GROUP BY primary_aaa_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 aaaa
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 aaaa

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