История изменений
Исправление Psilocybe, (текущая версия) :
with mg_cnt as ( select t.*, count(distinct ip) over ( patition by t.ip) num_ip from mg_user t) select * from mg_cnt where num_ip >5
Исходная версия Psilocybe, :
with mg_cnt as ( select t., count(distinct ip) over ( patition by t.ip) num_ip from mg_user t) select x. from mg_cnt x where x.num_ip >5