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
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
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