d Central Networks
> [EMAIL PROTECTED]
-Original Message-
From: Steve Howard [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 5:27 PM
To: Steve Howard; Purcell, Scott; [EMAIL PROTECTED]
Subject: RE: Select X number of rows
One correction, I forgot to alias the table in the t
.Column1)
BETWEEN 31 AND 40
Still ugly however you look at that one. :-(
Steve H.
-Original Message-
From: Steve Howard [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 7:08 PM
To: Purcell, Scott; [EMAIL PROTECTED]
Subject: RE: Select X number of rows
Three suggestions dependin
Three suggestions depending on the DBMS you are using:
1. This method is supported by MS SQL 7.0 or later:
SELECT TOP 20 Column1, Column2, Column3 FROM Sometable
WHERE Column1 NOT IN
(SELECT TOP 40 Column1 FROM Sometable
ORDER BY Column1)
ORDER BY COLUMN1
What database are you using, it's pretty easy to do with MySQL, since it
supports the LIMIT clause.
To find out the number of records from any DB's table, just run a select
count(*) query on it.
Ilya
-Original Message-
From: Purcell, Scott
To: '[EMAIL PROTECTED]'
Sent: 10/2/01 6:36 A
Yes.
Run a connect to each DB you want to work with. You can then run queries
with a where clause of 'rownum <= 20' to get a sampling of a table from each
DB. I'm not sure about a page count myself, but you can check the number of
records in each DB in each table with a 'select count(*)' query