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_ > ?

Comments

Post a Comment

Popular posts from this blog

SSL certification of you web site

-
This will create a certification file and send to free certification authority " https://certbot.eff.org " sponsored by linux foundation. Following are for apache deployment on Ubuntu compatible. For other configurations visit https://certbot.eff.org sudo apt-get install python-letsencrypt-apache sudo letsencrypt --apache
Read more

Installing MPICH2 on Ubuntu

-
Image
Installing MPICH2 parallel computing from package manager or Ubuntu software center, will need lot configurations of available real processors in the system environment. There for using MPICH2 from available .tar or .gz package is easier. To download MPICH2 package goto here: http://www.mcs.anl.gov/research/projects/mpich2/downloads/index.php?s=downloads or use here Direct link for mpich2-1.3a2.tar.gz change user to root or user super user privilege on every command sudo -i cd to the package location : #cd /location Then uncompress the package #tar xzvf filename.tar.gz go to the 'package root' : #cd filename then configure environment #./configure compile the package # make install the compiled package #make install Another small thing to do to start the mpich2 daemon: insert the following 3 lines to the /usr/local/bin/mpdlib.py as root import warnings warnings.filterwarnings('ignore', '.*the md5 module is deprecated.*', Depr...
Read more

ALLTALK WIRELESS SIGN LANGUAGE INTERPRETER

-
Image
Annual Technical Conference 2006 of IET-YMS Sri Lanka, 16 th  October 2010 Department of Electrical and Information Engineering, University of Ruhuna ALLTALK WIRELESS SIGN LANGUAGE INTERPRETER Edi risinghe E.A.M.M, Gamage K.G.C.P,  Kumara M.P.H.N,  Ra thnayake R.M.M.H Supervised by: Dr.   N.D Jayasundere Department of  Electrical and Information Engineering  - University of Ruhuna  - Sri Lanka The Knowledge Network                                                                The Institution of Engineering and Technology is registered as a charity organization 4 Abstract For many deaf people, sign language is the principle means of comm...
Read more