Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> comp.databases.oracle -> does sqlplus support :"select top 10 * from table1" syntax like MS SQL?

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

From: mlke <ml_ke_at_hotmail.com>
Date: 2 Mar 2004 12:16:35 -0800
Message-ID: <df2c70d1.0403021216.3af4acc6@posting.google.com>

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! Received on Tue Mar 02 2004 - 14:16:35 CST

This message: [ Message body ]
Next message: Mark C. Stock: "Re: How to use an array in the IN clause?"
Previous message: SAP BASIS Consultant: "Estimate in Reduction of Index Size by Reorganization?"
Next in thread: Jacob Grydholt Jensen: "Re: does sqlplus support :"select top 10 * from table1" syntax like MS SQL?"
Reply: Jacob Grydholt Jensen: "Re: does sqlplus support :"select top 10 * from table1" syntax like MS SQL?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US