Submitted Questions

  • How can I get recent 10 records out of 100 records

    HI all table contain some 1000 records, today I inserted 100 records into table, so I want first 10 records data from 100 records how can I retrieve

    kapil joshi

    • Sep 15th, 2012

    Select * from employees where rownum

    Manoj Kumar

    • Aug 28th, 2012

    Code
    1. SELECT * FROM (SELECT * FROM emp ORDER BY <created_date> DESC) WHERE rownum <11