Re: 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" <saurabh.dhawan@naukri.com> > To: <php-db@lists.php.net> > 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