• Home
  • kanthrirtn Answers

Answered Questions

  • Mar 03 2008
    08:08 PM
    35585
    64

    How do you print the last n rows or the first n rows of a table ?
    • bharaniprasanth

    Star Read Best Answer

    Editorial / Best Answer

    nirmal1in  

    • Member Since Jan-2010 | Jan 17th, 2010

    This can be accomplished in following way:

    Example: table - emp

    For First n rows:

    SELECT * FROM
    (SELECT empno,ename,job,row_number() over (order by ename desc) a
    FROM emp) x
    WHERE x.a < 5 --- say n is 5 display first 5 records

    For last n rows:

    SELECT * FROM
    (SELECT empno,ename,job,row_number() over (order by ename) a
    FROM emp) x
    WHERE x.a < 5

     FROM )WHERE .a<

    This query can be used for finding nth row also say n = 5

    SELECT * FROM
    (SELECT empno,ename,job,row_number() over (order by ename desc) a
    FROM emp) x
    WHERE x.a = 5

    deepthi

    • May 17th, 2012

    Code
    1. SELECT rownum,a.*FROM(SELECT rownum,b.*FROM emp b ORDER BY rownum DESC) a WHERE rownum <&n;