hi billm thanx but there is a small confusion i dont want to give count(*) > 1 in the having clause.Instead i want to implement max(count(*)).
That is i dont want to fetch records > 1 in having.i want to fetch the max count record alone.
please help me.
ur previous suggestion was very useful.
The last solution you gave just returns only one value if two drivers match the same criteria.
But i also noticed that u posted that it will return an arbitary row .
But i want all rows which match the criteria.