I think the mm driver for mysql does support this... You should consider
taking a look at www.mysql.org
Computers are like air conditioners - they stop working
properly when you open Windows
UNIX _IS_ user friendly. It's just selective about who its friends are.
______________________________________________
Sylvain Roche
Responsable d�veloppement
Add-Online
www.add-online.fr
70bis rue Bossuet
69006 LYON
France
tel : +33 472838583
fax: +33 472838584
-----Message d'origine-----
De : Giovanni Az�a Garc�a <[EMAIL PROTECTED]>
� : [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date : jeudi 23 d�cembre 1999 00:07
Objet : Re: OFF TOPIC: SQL
>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
===========================================================================
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
