.


:




:

































 

 

 

 





. , .

SELECT ., Max (.[ ]) AS [Max- ], Min (.[ ]) AS [Min- ]

FROM INNER JOIN ON .[N ] = .[N ]

GROUP BY .

HAVING .="";

54: , . : , ,. .. .

.

, . . , . ().

 

 

.17.

ANSI SQL:

SELECT ., ., .

FROM INNER JOIN ( INNER JOIN ON . = .) ON . = .

WHERE (.)>(SELECT Avg () FROM );

 

SELECT . AS [ ], . AS [ ], .[ ]

FROM INNER JOIN ON .[N ] = .[N ]

WHERE (((.[ ])>(SELECT Avg([ ]) FROM )));

.

4.1: 54

. . . OK.

. , . SLQ INTO.

SELECT ., .,

. INTO [ ]

FROM

SELECT . AS [ ],

. AS [ ],

.[ ] INTO [ ]

FROM

. , 43 . . (F11) , .





:


: 2015-10-19; !; : 429 |


:

:

80% - .
==> ...

1535 - | 1386 -


© 2015-2024 lektsii.org - -

: 0.008 .