SQL - : |
Strong Question Language |
Structured Query Line |
Structured Query Language |
SQL ''CREATE TABLE'' |
SQL ALTER TABLE'' |
SQL DROP TABLE'' : |
SQL ''CREATE VIEW'' : |
SQL INSERTINTO |
SQL UPDATE SET |
SQL DELETEFROM |
SQL ? |
SELECT |
EXTRACT |
OPEN |
UPDATE |
SQL ? |
SAVE |
UPDATE |
SAVE AS |
SELECT |
SQL ? |
REMOVE |
BLANK |
DELETE |
DROP |
SQL ? |
INSERT |
PUT |
ADD |
NEW |
SQL |
SELECT FROM |
SELECT |
INSERT INTO |
UPDATE...SET |
SELECT * , ... |
, * |
, * |
SELECT |
SELECT, WHERE |
SELECT, FROM |
SELECT GROUP BY |
SELECT, FROM, WHERE |
FROM SELECT |
, |
, |
WHERE SELECT ... |
/ |
, |
|
|
GROUP BY SELECT ... |
/ |
, |
, |
HAVING SELECT ... |
, |
SQL |
SELECT INTO |
SELECT |
INSERT INTO |
UPDATE...SET |
SQL |
SELECT INTO |
SELECT |
INSERT INTO |
UPDATE...SET |
SQL ? |
SELECT INTO |
SELECT |
INSERT INTO |
UPDATE...SET |
SQL ? |
SELECT INTO |
SELECT |
INSERT INTO |
UPDATE...SET |
SQL UPDATE SET |
UPDATE UPDATE SET |
, |
, |
, |
SQL ''SELECT INTO'' |
? |
NOSAME |
SC |
COUNT |
DISTINCT |
? |
SORT-ORDER |
ORDER |
ORDER BY |
SORT |
SQL ? |
ORDER BY < > |
ORDER BY < >DESC |
ORDER BY < > ASC |
SORT BY ASC |
SQL ? |
SORT-ORDER < > DESC |
ORDER BY < >DESC |
ORDER BY < >ASC |
SORT BY < >ASC |
SQL JET |
INNER JOIN |
LEFT OUTER JOIN |
LEFT OUTER JOIN |
WHERE |
ANSI SQL |
INNER JOIN |
LEFT OUTER JOIN |
DISTINCTROW |
WHERE |
ANSI SQL? |
AND |
OR |
NEAR |
NOT |
: AND , . |
: OR , . |
|
|
: AND , . OR , . |
SQL ? |
>=, > |
<=, < |
%, ^ |
<>, = |
SQL ? |
+, - |
>=, <= |
%, ^ |
*, \ |
SQL ? |
BETWEEN.. AND |
LIKE |
AND, OR, NOT |
IN |
IN SELECT |
, , |
, |
, , |
BETWEEN.. AND SELECT |
, , |
, |
, , |
: BETWEEN 10 AND 12 |
>=10 OR <=12 |
>=10 AND <=12 |
>10 AND <12 |
>10 OR <12 |
IN(20, 30, 50)? |
=20 AND =30 AND =50 |
=20 OR =30 OR =50 |
>20 OR >30 OR >50 |
>20 AND <50 |
LIKE : |
, , |
* LIKE : |
n |
n |
n |
() |
SUM |
AVG |
COUNT |
SUM/N |
() |
SUM |
AVG |
COUNT |
STDEV |
, : |
SELECT ALL |
SELECT DISTINCT |
SELECT DICTINCT ROW |
SELECT NOT DUBLICATE |
5 : |
SELECT DISTINCT |
SELECT 5 |
SELECT TOP 5 |
SELECT TOP 5% |
, : |
SELECT DISTINCT |
SELECT ALL |
SELECT TOP |
SELECT * |
SELECT |