does sqlplus support :"select top 10 * from table1" syntax like MS SQL?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • mlke

    does sqlplus support :"select top 10 * from table1" syntax like MS SQL?

    I would like to select the top 10 record from a table? How can I do it?
    In MS SQL, it's easy using select top 10 from table1. But in oracle database,
    I can't use top, anyone have any suggestions? Thanks!
Working...