|
09.01.2019, 17:04
#39757357
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
Ссылка на профиль пользователя:
|
|
|
Участник
Откуда: Middlebury, CT USA
Сообщения: 10 588
Рейтинг:
0
/ 0
|
|
|
|
Andy_OLAPSY,
Не "over(partition by tbl.tovar ", а "over(partiont by tbl.tovar, tbl.city_from, tbl.city_to"...
Да ну?
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
SQL> select case row_number() over(partition by d.dname order by e.ename)
2 when 1 then d.dname
3 end dname,
4 e.job,
5 e.ename
6 from dept d,
7 emp e
8 where e.deptno = d.deptno
9 order by d.dname,
10 row_number() over(partition by d.dname order by e.ename)
11 /
DNAME JOB ENAME
-------------- --------- ----------
ACCOUNTING MANAGER CLARK
PRESIDENT KING
CLERK MILLER
RESEARCH CLERK ADAMS
ANALYST FORD
MANAGER JONES
ANALYST SCOTT
CLERK SMITH
SALES SALESMAN ALLEN
MANAGER BLAKE
CLERK JAMES
SALESMAN MARTIN
SALESMAN TURNER
SALESMAN WARD
14 rows selected.
SQL> select case row_number() over(partition by d.dname,e.job,e.ename order by e.ename)
2 when 1 then d.dname
3 end dname,
4 e.job,
5 e.ename
6 from dept d,
7 emp e
8 where e.deptno = d.deptno
9 order by d.dname,
10 row_number() over(partition by d.dname,e.job,e.ename order by e.ename)
11 /
DNAME JOB ENAME
-------------- --------- ----------
ACCOUNTING PRESIDENT KING
ACCOUNTING MANAGER CLARK
ACCOUNTING CLERK MILLER
RESEARCH CLERK ADAMS
RESEARCH ANALYST SCOTT
RESEARCH ANALYST FORD
RESEARCH CLERK SMITH
RESEARCH MANAGER JONES
SALES CLERK JAMES
SALES MANAGER BLAKE
SALES SALESMAN ALLEN
SALES SALESMAN MARTIN
SALES SALESMAN TURNER
SALES SALESMAN WARD
14 rows selected.
SQL>
SY. |
|
|
