limiting returned amount of rows

Hi!

There is probably no way... I use ADO to read data from _any_ database;
basically I dont know what is in the other end :-)

If I'd like to read out a number of data, e.g. latest 1000 rows (og
let's say 4000000), I'd need a way to limit that.
Is there a uniform way to do that, when I might use Access, SQL server,
Interbase and MySQL or Oracle?

The select top 1000 works only with M$ products.

BR
Sonnich

BTW: if not possible, then how do I do it with Interbase and MySQL?

.

Relevant Pages

  • Re: Reading large csv-file and removing duplicates
    ... I tried to import the data in a Ms Access 2007 database, ... Use NTFS and MySQL (still free? ... dont know), ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Will FireBird Replace MSDE???
    ... > Firebird is Borland Interbase is Groton Database's Interbase is a ... I think many applications will be fine running Firebird, ... fine running MySQL or MSDE. ... Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL ...
    (microsoft.public.sqlserver.msde)
  • Re: MySQL Database problem (probably already solved in a message, but this is somewhat urgent)
    ... MySQL server has a database with a table, ... columns, an FSR column, and a password column. ... checked if the supposed arrays that were returned were actually arrays ...
    (comp.lang.php)
  • RE: FreeBSD 5.3 MySQL Performance
    ... versions of Linux and FreeBSD for most tests. ... > popular with the ATA disk drive manufacturers. ... > Many companies have used FreeBSD and MySQL for years and years. ... it is not often that you have such a small database and such a large ...
    (freebsd-questions)
  • ANN: Database Designer for MySQL version 1.6 is released
    ... The new version 1.6 of MicroOLAP Database Designer for MySQL has been ... The secure shell (SSH) tunneling is now implemented in Database ...
    (borland.public.delphi.thirdpartytools.general)