When selecting from the pseudo table rownum _and_ using
a order by clause i would suggest the use of a inline view.
Otherwise your order by clause won´t work.
Try this instead:
SELECT * FROM (SELECT * FROM customer_table WHERE rownum < 6)
ORDER BY money_spent
Regards, Bip
> -----Original Message-----
> From: Gulam Irfani [mailto:[EMAIL PROTECTED]]
> Sent: den 22 december 1999 15:07
> To: [EMAIL PROTECTED]
> Subject: Re: OFF TOPIC: SQL
>
>
> Hi,
> I am not a big expert but I would suggest you to run
> this query.
>
> select * from CUSTOMER_TABLE where rownum < 6 order
> by MONEY_SPENT.
>
> G Irfani
> NIIT USA Inc.
>
>
> ______________________________ Reply Separator
> _________________________________
> Subject: Re: OFF TOPIC: SQL
> Author: <[EMAIL PROTECTED]> at SMTP-GATEWAY
> Date: 12/22/99 4:59 PM
>
>
> Pertaining to Oracle, if you are using orderby clause the
> result I believe
> would not be correct....
> Check oracle documentation for rownum clause....
>
> > Remain Kooollll......,
> > Mohamed Ashraf Memon
> > Advanced Micro Devices (Singapore)
> > TEL : 7969-888 X 39826
> > FAX : 4492-360
> > DID : 7969-826
> > Email : [EMAIL PROTECTED]
> >
> >
> >
> > -----Original Message-----
> > From: Nicholas Barrington
> [SMTP:[EMAIL PROTECTED]]
> > Sent: Wednesday, December 22, 1999 8:57 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: OFF TOPIC: SQL
> >
> > ANSI SQL supports the TOP predicate. It works like this :
> >
> > SELECT TOP 10 * FROM my_table;
> >
> > -----Original Message-----
> > From: Richard Yee [mailto:[EMAIL PROTECTED]]
> > Sent: Saturday, December 18, 1999 10:07 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: OFF TOPIC: SQL
> >
> >
> > Giovanni,
> > In Oracle you can use the ROWNUM pseudo column to
> restrict the number
> > of
> > records returned. I am not sure if this is supported in
> other databases.
> >
> > ie. Select * from my_table where ROWNUM < 10;
> > This will return at most 10 rows.
> >
> > Regards,
> >
> > Richard.
> >
> >
> >
> ==============================================================
> ============
> > ==
> > ====
> > Richard Yee
> > DMC1 Corporation
> > 305 W. Evelyn Ave.
> > Mtn. View, CA. 94041
> > 650-963-3116
> > [EMAIL PROTECTED]
> >
> ==============================================================
> ============
> > ==
> > ====
> >
> >
> > -----Original Message-----
> > From: Giovanni Azúa García [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, December 17, 1999 12:38 PM
> > To: [EMAIL PROTECTED]
> > Subject: OFF TOPIC: SQL
> >
> >
> > Hello all,
> >
> > I have worked a lot with SQL but I would like to know
> > how could I limit the number of rows one SELECT returns?
> >
> > For example, if I had a table with Customers having for each
> > how much money they have spent in my company and I wanted to
> > know the 5 customers that have spent the most, *ONLY* five:
> >
> > SELECT *
> > FROM CUSTOMER_TABLE
> > ORDER BY MONEY_SPENT; // This would return all rows ordered
> >
> > How could I limit this using SQL specifying the ammount of rows in
> > advance?
> >
> > I mean without having to iterate over all existing records.
> > The only approach I have found is using the HAVING option
> so I could say
> > HAVING MONEY_SPENT > X but how can I determine a X for that there
> > are only Y records.
> >
> > Thanks in advance,
> > Giovanni
> >
> > PD: Maybe I'm expecting too much from SQL
> >
> > BCs. Giovanni Azúa García
> > Bachelor in Computer Science
> > Banking and Economic Information Center
> > Central Bank of Cuba
> > ICQ# 20725388
> > e-mail: [EMAIL PROTECTED]
> >
> >
> ==============================================================
> ============
> > =
> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> > JSP-INTEREST".
> > FAQs on JSP can be found at:
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.html
> >
> >
> ==============================================================
> ============
> > =
> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> > JSP-INTEREST".
> > FAQs on JSP can be found at:
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.html
>
> ==============================================================
> =============
> To unsubscribe: mailto [EMAIL PROTECTED] with body:
> "signoff JSP-INTEREST".
> FAQs on JSP can be found at:
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
>
> ==============================================================
> =============
> To unsubscribe: mailto [EMAIL PROTECTED] with body:
> "signoff JSP-INTEREST".
> FAQs on JSP can be found at:
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
