Convert SQL Native to JPQL

0

I have this query

select distinct p.nombre, 
       p.total,
       p.clie_id
from(select cli.nombre as nombre, 
        cli.clie_id,
        cue.cuen_id as cuenta, 
        count(cue.clie_id) over(partition by cli.clie_id) as total 
     from Cuenta cue, 
      Cliente cli 
     where cue.clie_id = cli.clie_id) as  p 
where total > 1 order by p.clie_id asc;

But I need to pass it to JPQL .

    
asked by GeorgiG 06.08.2017 в 21:59
source

0 answers