For Programmers: Free Programming Magazines  


Home > Archive > PHP DB > May 2005 > Re: [PHP-DB] Limiting Results









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: [PHP-DB] Limiting Results
Joseph Crawford

2005-05-19, 3:56 pm

You could always try the LIMIT keyword :)

select a.college, a.state, a.cd <http://a.cd/>, b.rep from a, b

where

a.state = "al" and a.cd <http://a.cd/> = "3" or
a.state = "az" and a.cd <http://a.cd/> = "1" and

a.state = b.state and
a.cd <http://a.cd/> = b.cd <http://b.cd/>

LIMIT 50

--
Joseph Crawford Jr.
Codebowl Solutions
codebowl@gmail.com

Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com