Oracle pagination query example

    select
        * 
    from
        ( select
            row_.*,
            rownum rownum_ 
        from
            ( 
YOUR SELECT STATEMENT WITH WHERE,GROUP,ORDER,AGGREGATES,ETC

 ) row_ ) 
        where
            rownum_ <= ? 
            and rownum_ > ?