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_at_posting.google.com>
Date: 2 Mar 2004 12:16:35 -0800
Message-ID: <df2c70d1.0403021216.3af4acc6_at_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 - 21:16:35 CET