Home Forums SQL Server 2008 Working with Oracle Error when selecting top N records from oracle RE: Error when selecting top N records from oracle

  • July 21, 2014 at 7:55 am

    #1731018

    Oracle code uses: "rownum < 100". It does not use TOP command.

    Ex: Select * from 'table1' where rownum < 100;