Re: [PHP-DB] how to select rows with repeated coloumns in one query????
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
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
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] how to select rows with repeated coloumns in one query????
I have a table called studs with coloumns as :
Sno.namegrade
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
