Re: [SQL] fetching rows

2000-10-30 Thread Martin Christensen
> "Jeff" == Jeff Hoffmann <[EMAIL PROTECTED]> writes: Jeff> you can't do that with a cursor, but you can use they mysql-ism Jeff> called a limit clause. for example, to fetch rows 26-50 from Jeff> that query, you'd do: Jeff> select * from films limit 25,26; Jeff> or Jeff> select * from files

[SQL] Many-to-one subquery

2000-08-16 Thread Martin Christensen
I have a problem that I have not been able to solve efficiently, and I'm confident that it can be done in a single query. I have a mailing list archive that I want to do some statistics on. It would tremendously ease my work if I could extract such statistics for each individual poster in one go.