Re: QUERY HELP NEEDED

From: <fwdkhan_at_gmail.com>
Date: 11 Mar 2007 22:57:16 -0700
Message-ID: <1173679036.103760.192510@n33g2000cwc.googlegroups.com>

PROB SOLVED. with some minor changes in David's query i m able to solve the problem. This is the query i m using

select * from
(SELECT COUNT(TABLE1.COL1) AS Expr1, TABLE2.COL2 FROM TABLE1,TABLE2 where TABLE1.COL1 = TABLE2.COL1 GROUP BY TABLE2.COL2)
where expr1 = ( SELECT TOP 1 COUNT(TABLE1.COL1) As Expr1 FROM TABLE1,TABLE2 where TABLE1.COL1 = TABLE2.COL1 GROUP BY TABLE2.COL2
ORDER BY Expr1 desc);

also tell me if there are any other alternatives i can use. and Thanku all of u very much. Received on Mon Mar 12 2007 - 00:57:16 CDT