4 messages in com.mysql.lists.win32Re: select question| From | Sent On | Attachments |
|---|---|---|
| Frank Tudor | 29 Apr 2004 08:37 | |
| Ignatius Reilly | 29 Apr 2004 09:02 | |
| Frank Tudor | 29 Apr 2004 09:11 | |
| Graeme St.Clair | 29 Apr 2004 09:52 |
| Subject: | Re: select question![]() |
|---|---|
| From: | Frank Tudor (fran...@yahoo.com) |
| Date: | 04/29/2004 09:11:15 AM |
| List: | com.mysql.lists.win32 |
This did it!!!!
:)
Thanks!
Frank
--- Ignatius Reilly <igna...@free.fr> wrote:
WHERE page.pageid BETWEEN 1 AND 10
_________________________
----- Original Message ----- From: "Frank Tudor" <fran...@yahoo.com> To: <mysq...@lists.mysql.com> Sent: Thursday, April 29, 2004 5:37 PM Subject: select question
Here is a sql statment I need modified.
select sum(duration)/60 from course_material where section = '1';
There are also course pages in a table called pages and these pages are numbered 1 throuh 20.
If I neded to grab pages one through 10 what would the sql look like?
So logic:
where pages are between 1 and 10
how would I do this?
thanks, Frank
__________________________________ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover
-- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/win32?unsub=igna...@free.fr
__________________________________ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover




