-
-
Select
SELECT. SELECT . SELECT .., .. . , SELECT "" SQL.
SELECT
[ INTO __.]
FROM _
[WHERE ]
[GROUP BY ]
[HAVING ]
[UNION ]
[ORDER BY [ASC | DESC]]
[COMPUTE ]
[FOR]
[OPTION ]
SELECT
SELECT [ALL | DISTINCT] [TOP n [PERCENT] [WITH TIES]]
DISTINCT
TOP n [PERCENT] . - [
]
WITH TIES
, - TOP n.
INTO .
FROM - { | } []
[,{ | } []]}...
WHERE - , TRUE FALSE.
, TRUE,
.
: =, <>,!=, >, >=,!>, <, >=,!<, NOT
GROUP BY -
, ,
.
,
.
:
COUNT(_)
COUNT(*)
MAX(_)- .
MIN(_) - .
AVG ( _)
.
SUM( _)
:
SELECT ot, SUM(SN), COUNT(*) FROM i1 GROUP BY ot
HAVING GROUP BY, -
, WHERE
UNION -
1
UNION [ALL]
2
UNION [ALL]
3
.
1+2+3+( )
. ALL .
|
|
:
SELECT ot,tn,ok FROM bd WHERE ot=200
UNION ALL
SELECT ot,tn,sn FROM i1 WHERE ot=11
UNION ALL
SELECT ot,tn,su FROM i2 WHERE ot=21
ORDER BY { . [ASC | DESC]}[,n]
:
SELECT ot, tn, f, ok from bd ORDER BY ot, f DESC
COMPUTE :
AVG |COUNT | MAX | MIN | SUM
() [,n]
[BY () [,n]
:
SELECT ot,tn,ok,nal FROM bd WHERE ot=200 COMPUTE SUM(ok),
COUNT(ok), AVG(ok), AVG(nal)
FOR . DB-Library XML
OPTION
,
Create database database_name
:
Create database Newbase;
Drop database Newbase