CREATE TABLE Test
(
   F1 varchar(124),F2 varchar(124),F3 varchar(124)
)
INSERT INTO TEST ( F1,F2,F3 ) VALUES ( 'A','B','C' )
INSERT INTO TEST (  F1,F3 ) VALUES ( 'D','E' )
INSERT INTO TEST (  F1,F3 ) VALUES ( 'F','I','G' )
INSERT INTO TEST (  F1,'K' )
INSERT INTO TEST (  F1,'K','K' )

现在,如果我运行此查询：@H_301_6@

SELECT B.f2,COUNT(*) AS CNT  
FROM 
(
select F1,F3 from Test
where F2='B'
 )AS A
    INNER JOIN  Test AS B
   ON A.F1 = B.F1 AND  A.F3 = B.F3
GROUP BY B.F2 
ORDER BY CNT DESC

该表有1米行.
什么是更好的方法来做到这一点？@H_301_6@