.


:




:

































 

 

 

 


5. .




 

 

SELECT [ ].ID_, [ ]._, [ ]._, [ ]._, [ ].[ ], [ ]., [ ]., [ ]., [ ]., [ ].[-__], " : "+[_]+" : "+[_]+", : "+[_]+". : "+[]+" ., : "+[]+" ., : "+[]+" . : "+[]+" . "+[-__]+" . : "+[ ] AS

FROM [ ];

 

 

SELECT [ ].ID_, [ ]._, [ ]._, [ ]._, [ ].ID_, [ ]., [ ]., [ ]., [ ]., [ ].[-__], [ ].[ ], [ ].[ ]

FROM [ ];

 

-

 

SELECT [_]*1.9 AS _, [ _1].ID_, [ _1].[ ], [ _1].ID_, [ _1].[ ], [ _1]._, [_]*1.9 AS _

FROM [ ] AS [ _1];

 

 

 

SELECT [ 2015].ID_, [ 2014].1, [ 2014].2, [ 2014].3, [ 2014].4, [ 2014].5, [ 2014].6, [ 2014].7, [ 2014].8, [ 2014].9, [ 2014].10, [ 2014].11, [ 2014].12, [ 2015].13, [ 2015].14, [ 2015].15, [ 2015].16, [ 2015].17, [ 2015].18, [ 2015].19, [ 2015].20, [ 2015].21, [ 2015].22, [ 2015].23, [ 2015].24

FROM [ 2015] INNER JOIN [ 2014] ON [ 2015].ID_ = [ 2014].ID_;

 

 

SELECT [- 2014].ID_, [- 2014].1, [- 2014].2, [- 2014].3, [- 2014].4, [- 2014].5, [- 2014].6, [- 2014].7, [- 2014].8, [- 2014].9, [- 2014].10, [- 2014].11, [- 2014].12, [- 2015].13, [- 2015].14, [- 2015].15, [- 2015].16, [- 2015].17, [- 2015].18, [- 2015].19, [- 2015].20, [- 2015].21, [- 2015].22, [- 2015].23, [- 2015].24

FROM [- 2014] INNER JOIN [- 2015] ON [- 2014].ID_ = [- 2015].ID_;

 

 

SELECT [ 2].ID_, [13]-[12] AS 13, [14]-[13] AS 14, [15]-[14] AS 15, [16]-[15] AS 16, [17]-[16] AS 17, [18]-[17] AS 18, [19]-[18] AS 19, [20]-[19] AS 20, [21]-[20] AS 21, [22]-[21] AS 22, [23]-[22] AS 23, [24]-[23] AS 24

FROM [ 2] INNER JOIN [ 2015] ON [ 2].ID_ = [ 2015].ID_;

 

 

SELECT [ 2014].1, [ 2014].2, [ 2014].3, [ 2014].4, [ 2014].5, [ 2014].6, [ 2014].7, [ 2014].8, [ 2014].9, [ 2014].10, [ 2014].11, [ 2014].12, [ 2015].13, [ 2015].14, [ 2015].15, [ 2015].16, [ 2015].17, [ 2015].18, [ 2015].19, [ 2015].20, [ 2015].21, [ 2015].22, [ 2015].23, [ 2015].24, [ 2014].ID_

FROM [ 2015] INNER JOIN [ 2014] ON [ 2015].ID_ = [ 2014].ID_;

SELECT [ 2014].1, [ 2014].2, [ 2014].3, [ 2014].4, [ 2014].5, [ 2014].6, [ 2014].7, [ 2014].8, [ 2014].9, [ 2014].10, [ 2014].11, [ 2014].12, [ 2015].13, [ 2015].14, [ 2015].15, [ 2015].16, [ 2015].17, [ 2015].18, [ 2015].19, [ 2015].20, [ 2015].21, [ 2015].22, [ 2015].23, [ 2015].24, [ 2014].ID_

FROM [ 2015] INNER JOIN [ 2014] ON [ 2015].ID_ = [ 2014].ID_;

 

 

SELECT .ID_, ., ., .ID_, .ID__, ._, [ ].__, [ ].__, [ ].__, [ ].__, [ ].__

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

WHERE (((.[ID__])<>0));

 

 

SELECT [ ].ID_, [1]+[1] AS 1, [2]+[2] AS 2, [3]+[3] AS 3, [4]+[4] AS 4, [5]+[5] AS 5, [6]+[6] AS 6, [7]+[7] AS 7, [8]+[8] AS 8, [9]+[9] AS 9, [10]+[10] AS 10, [11]+[11] AS 11, [12]+[12] AS 12, [13]+[13] AS 13, [14]+[14] AS 14, [15]+[15] AS 15, [16]+[16] AS 16, [17]+[17] AS 17, [18]+[18] AS 18, [19]+[19] AS 19, [20]+[20] AS 20, [21]+[21] AS 21, [22]+[22] AS 22, [23]+[23] AS 23, [24]+[24] AS 24

FROM ([ ] INNER JOIN [ 2014] ON [ ].ID_ = [ 2014].ID_) INNER JOIN [ 2015] ON ([ 2015].ID_ = [ 2014].ID_) AND ([ ].ID_ = [ 2015].ID_);

. .

 

 

_________2015 . ______________ __ ____

 





:


: 2016-11-24; !; : 329 |


:

:

, ,
==> ...

1640 - | 1557 -


© 2015-2024 lektsii.org - -

: 0.016 .