!==

==!

=!

!=

WHERE id >=3 AND id <= 3

WHERE id IN (2, 3, 4)

WHERE id BETWEEN 3 AND 4

WHERE id >= 3 OR id <= 3

Mezőknek és tábláknak

Mezőknek és záradékoknak

Tábláknak

Mezőknek

DELETE WHERE condition FROM table_name;

DELETE WHERE table_name FROM condition;

DELETE FROM table_name WHERE condition;

DELETE FROM condition WHERE table_name

9

Hibás az utasítás

0

16

WHERE belepes >= 1958 AND belepes <= 2013

WHERE (belepes > 1958) AND (belepes < 2013)

WHERE belepes > 1958 AND  belepes < 2013

WHERE belepes > 1958 OR belepes < 2013

SELECT - FROM - ORDER BY - WHERE - GROUP BY - HAVING

Egyikkel sem a felsoroltak közül.

SELECT - FROM - ORDER BY - WHERE  - ORDER BY - HAVING

SELECT - FROM - WHERE - GROUP BY - HAVING - ORDER BY

SELECT - WHERE - FROM - HAVING - ORDER BY - GROUP BY

TOP/LIMIT

TAKE

LAST

NUMBER OF

WHERE kártya LIKE "%pikk"

WHERE kártya LIKE "%pikk%"

WHERE kártya LIKE "pikk"

BASED ON

GROUP BY

IN BETWEEN

INSIDE OF