List:General Discussion« Previous MessageNext Message »
From:Michael Stassen Date:October 14 2004 5:11am
Subject:Re: SELECT and LIMIT question
View as plain text  
Why do you think it doesn't work with LIMIT?  Do you want 5 of each?

Michael

Jay K wrote:

> Hi,
> 
> I have multiple queries like this:
> 
> SELECT col1, col2, col3, col4 FROM table1, table2
> where table1.col1 = table2.col1 and table1.col2 = 1
> ORDER BY col3 desc LIMIT 5
> 
> and
> 
> SELECT col1, col2, col3, col4 FROM table1, table2
> where table1.col1 = table2.col1 and table1.col2 = 2
> ORDER BY col3 desc LIMIT 5
> 
> The only difference is in the WHERE clause table1.col2
> = x.
> 
> I would like to have one statement instead of multiple
> statements and though about using IN clause like:
> 
> SELECT col1, col2, col3, col4 FROM table1, table2
> where table1.col1 = table2.col1 and table1.col2 IN
> (1,2,3) ORDER BY col3 desc LIMIT 5
> 
> It works without LIMIT, but I need to use the LIMIT.
> 
> Any help is appreciated.
> 
> Thanks in advance,
> Jay
> 
> 
> 		
> _______________________________
> Do you Yahoo!?
> Declare Yourself - Register online to vote today!
> http://vote.yahoo.com
> 
Thread
SELECT and LIMIT questionJay K14 Oct
  • Re: SELECT and LIMIT questionMichael Stassen14 Oct
    • Re: SELECT and LIMIT questionJay K14 Oct
      • Re: SELECT and LIMIT questionSGreen14 Oct
        • Re: SELECT and LIMIT questionMichael Stassen14 Oct
          • Re: SELECT and LIMIT questionJay K14 Oct
            • Re: SELECT and LIMIT questionSGreen14 Oct