SQL-
1. GTD06-07.
2. GTD06-07.
( COUNT(*)).
3. , sum-, .
4. ,
4.1. ;
4.2. , ;
4.3. , ߔ;
4.4. ߔ ߔ;
4.5. .
5. , :
5.1. ;
5.2. , .
( ORDER BY).
6. :
6.1. ;
6.2. ;
6.3. /.
7. :
SELECT " " + [First-] + " " + Str([]) +
" " + [First-] + " " + [] +
" " + Str([Sum-]) + " ."
AS [" "]
FROM GTD06_07
WHERE [ ] = ""
ORDER BY [];
( Str() )
. SQL SQL-.
1. GTD06_07
( ).
2. , Ĕ, First-, Sum- .
3. ( ). 50, 10 %.
4. , , :
4.1. ;
4.2. , ;
4.3. , , In;
4.4. .
( ).
5. , , :
Like [ ] & "*"
.
6. , , ( ).
7. , :
7.1. ;
7.2. , .
( ).
8. :
|
|
8.1. ;
8.2. ;
8.3. /
( ).
. SQL SQL-.
1. GDT06_07 :
1.1. First-;
1.2. ;
1.3. First-;
1.4. .
. -> ( , )
2. , , .
. .
3. First-, , 2006 .
4. 2, 3 . .
. , count(*).
5. / .
6. /:
6.1. .
6.2. .
. sum() .
7. ( ) .
. min() max().
8. .
. ( ), , avg().