敗家貓

query := 'select *
                      from  ( select a.*, rownum r
                              from (
                                    select
                                            E.Name,
                                            E.ID,
                                    from Employee E
                                    group by  E.Name,E.ID
                                    ) a
                              where rownum <= '|| gHigherBound ||'
                            ) b
                      where r > '|| gLowerBound ||'';