Hi all,
Thanks for your replies but I'm working with Inprise's INTERBASE Server
and there isn't ANSI SQL support to the TOP predicate or any other.
I could actually limit the number of rows in the client side (or in the
server side too) using DataSet's rowcount or something like that but
that would be after the SQL Server SPEND PROCESSOR time executing the full
SELECT
Unfortunately there is not ANSI SQL support for this feature
I should consider migrating from INTERBASE to either SQL Server or
Oracle.
Thanks to all,
Giovanni
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]
> -----Original Message-----
> From: Memon Mohamed Ashraf [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 22, 1999 4:00 AM
> To: [EMAIL PROTECTED]
> Subject: Re: OFF TOPIC: SQL
>
>
> 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
