[ADMIN] windown function count Unexpected results

Поиск
Список
Период
Сортировка
От winston cheung
Тема [ADMIN] windown function count Unexpected results
Дата
Msg-id eaec97a5-9412-7edc-15ff-c5c193649c75@163.com
обсуждение исходный текст
Ответы Re: [ADMIN] windown function count Unexpected results
Re: [ADMIN] windown function count Unexpected results
Список pgsql-admin
hello

When I used the count in the window function, I found that the results
were not true. In the table I use department_id as a partition
condition, I think when department_id = 30, the calculation of salary
<3000 should be 4, when department_id = 50,the calculation of salary <
3000 should be 20, why the value of each line are different?

Thanks a lot!

postgres@160.40:5410/testdb=# select department_id as dep_id,
concat(first_name, ' ', last_name) as employee_name, salary, count(*)
over w from employees where salary<3000 window w as (partition by
department_id order by salary desc);
  dep_id |   employee_name   | salary  | count
--------+-------------------+---------+-------
      30 | Shelli Baida      | 2900.00 |     1
      30 | Sigal Tobias      | 2800.00 |     2
      30 | Guy Himuro        | 2600.00 |     3
      30 | Karen Colmenares  | 2500.00 |     4
      50 | Michael Rogers    | 2900.00 |     2
      50 | Timothy Gates     | 2900.00 |     2
      50 | Vance Jones       | 2800.00 |     5
      50 | Mozhe Atkinson    | 2800.00 |     5
      50 | Girard Geoni      | 2800.00 |     5
      50 | John Seo          | 2700.00 |     7
      50 | Irene Mikkilineni | 2700.00 |     7
      50 | Douglas Grant     | 2600.00 |    10
      50 | Randall Matos     | 2600.00 |    10
      50 | Donald OConnell   | 2600.00 |    10
      50 | Joshua Patel      | 2500.00 |    15
      50 | Peter Vargas      | 2500.00 |    15
      50 | Martha Sullivan   | 2500.00 |    15
      50 | James Marlow      | 2500.00 |    15
      50 | Randall Perkins   | 2500.00 |    15
      50 | James Landry      | 2400.00 |    17
      50 | Ki Gee            | 2400.00 |    17
      50 | Hazel Philtanker  | 2200.00 |    19
      50 | Steven Markle     | 2200.00 |    19
      50 | TJ Olson          | 2100.00 |    20
(24 rows)


winston , regards




В списке pgsql-admin по дате отправления:

Предыдущее
От: Stéphane KANSCHINE
Дата:
Сообщение: Re: [ADMIN] Setting wild card IP's on postgres
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [ADMIN] windown function count Unexpected results