Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Simple Query of multiple record

Simple Query of multiple record

From: Joseph Jao <jjao_at_idt.net>
Date: 1997/03/12
Message-ID: <33273FF8.F08@idt.net>#1/1

Hi, I tried to make a simple SQL command query to get the names of 3 top paid persons. "Select name, sal from emp where rownum<4 order by sal desc;" doesn't work. "Select name, sal from emp order by sal desc;" works but it'll bring everything. Can anyone help me?

jjao_at_idt.net Received on Wed Mar 12 1997 - 00:00:00 CST

Original text of this message

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