Select distinct aircraft_code, count (flight_id) over(partition by aircraft_code) as flights_count, count (flight_id) over

Question

Select distinct aircraft_code, count (flight_id) over(partition by aircraft_code) as flights_count, count (flight_id) over

() as all_count,
count (flight_id) over(partition by aircraft_code)/count (flight_id) over()
from flights f

Подскажите, пожалуйста, почему последняя оконная функция не считает долю, а выдает ноль? Хотя первые две функции отрабатывают нормально?

#backend #devops #pgsql #programming #russian

0

20.11.2019