|
|
|
Помогите с парой задачек
|
|||
|---|---|---|---|
|
#18+
Народ, только начал учить Oracle SQL, не могу решить две задачки никак для демобазы. Спасибо всем, кто поможет. 1. Print out salary grade, number in that grade and average salary within the grade, but only fot those grades with a total salary exceeding $3500. 2. Show the highest and lowest compensation (sal plus commission) in each salary grade. Remember, some employee have no comissions. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 08.05.2002, 21:40 |
|
||
|
|
start [/forum/topic.php?fid=52&msg=32029804&tid=1993350]: |
0ms |
get settings: |
11ms |
get forum list: |
14ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
36ms |
get topic data: |
12ms |
get forum data: |
2ms |
get page messages: |
35ms |
get tp. blocked users: |
2ms |
| others: | 15ms |
| total: | 135ms |
| 0 / 0 |
