Re: Limiting # of hits via SQL
From: [Mr. C. V. Raman Phone # <rvc_at_farshad.cs.wayne.edu>
Date: 1995/06/22
Message-ID: <3sc89j$tq_at_wsu-cs.cs.wayne.edu>#1/1
Date: 1995/06/22
Message-ID: <3sc89j$tq_at_wsu-cs.cs.wayne.edu>#1/1
In article <3rl3d0$4mh_at_male.EBay.Sun.COM> bps3_at_bps3.EBay.Sun.COM writes:
>In article 95Jun13115024_at_adwyer.gsfc.nasa.gov, johns_at_adwyer.gsfc.nasa.gov (Steve Johns) writes:
>>Can someone mention to me how to tell SQLplus to only return the first
>>'n' hits?
>
>
>... and rownum < 11
>
>
>
>
>
Why, Make use of the pseudo column ROWNUM!!
Query would be something like:
Select col1,col2 from tablename where rownum < 10
C.V.Raman Received on Thu Jun 22 1995 - 00:00:00 CEST