, ID_ . , , , .
.
5. , 10. .
SELECT _, AVG (__) AS ' '
FROM T JOIN Pr
ON . ID_ = Pr.
WHERE __ > 10
GROUP BY _
, , NATURAL. ON .
, ID_ ( , ), , 3,
6.
SELECT ., .
FROM NATURAL JOIN
7. , ,
Declare @r float
@r=0.078
SELECT ., .__,
Round (.__*.*@r, 3) AS
FROM T INNER JOIN Pr
ON T.ID_= Pr.
.
:
1. ;
2. ;
3. .
:
SELECT < >
FROM < , >
< LEFT | RIGHT [OUTER] JOIN >
< , >
[ON < > ]
, OUTER .
, , , , .
, .
, null.
:
8.
SELECT T.,Pr., Pr.__
FROM LEFT OUTER JOIN Pr
ON .ID_ = Pr.
, .
|
|
9.
- 1.01.11 20.04.11
SELECT P. AS , COUNT( .)* SUM (.__)
AS
FROM P LEFT JOIN Post
ON P.ID_ = Post.
WHERE Post. BETWEEN 1.01.11 AND 20.04.11
GROUP BY P._
, .
, null.
ANSI:
10.
, , .
SELECT P._,
FROM Tel RIGHT JOIN P
ON P.ID_ = Tel._
, , . null.
UNION
union , select, .
union :
SELECT 1
UNION [ALL]
SELECT 2
:
1. union ;
2. ( , ), SQL Server . .
select union .
ALL, , .
11. . (, , ) :
,
,
.
. :
SELECT , [ ] FROM
UNION ALL
SELECT , [ ] FROM
UNION ALL
SELECT , [ ] FROM [ ]
|
|