Actually, it's MySQL 4.1 and above that supports subselects.

On Tue, 30 Sep 2003 12:24:51 +0530, Nitin spoke thusly about Re: 
[PHP-DB] how to select rows with repeated coloumns in one query????:
> with Mysql 4.0 and above, u can use subqueries, so that u can put first
> query in the where clause of second query itself.
> 
> Nitin
> 
> ----- Original Message ----- 
> From: "Saurabh Dhawan" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, September 30, 2003 11:26 AM
> Subject: [PHP-DB] how to select rows with repeated coloumns in one query????
> 
> 
>>  I have a table called studs with coloumns as :
>>  Sno. name grade
>>  1 aa 1
>>  2 bb 1
>>  3 cc 2
>>  4 dd 3
>>  5 ee 4
>>  6 ff 4
>>  7 gg 4
>>  8 hh 5
>> 
>>  Now i want to see only those rows which have value of grade repeated
>>  atleast in one other row i.e.
>>  The result should contain row no's 1,2(with grade 1) and 5,6,7(with grade
> 4)
>> 
>>  in two queries this cud be done as :
>>  select sno, count(grade) as cnt from studs group by grade having cnt>1
>>  and then
>>  select * from studs where sno in ('result of previous query')
>> 
>>  -- 
>>  PHP Database Mailing List (http://www.php.net/)
>>  To unsubscribe, visit: http://www.php.net/unsub.php

---
Listserv only address.
Jeff Shapiro

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to