Newbie query

[Rohit Nepali]

Hi I'm have problem with a simple query. I hope someone can help me.
The table structure is :
Doctor(DName,BirthDate)
Patient(PName,BirthDate)
IsDoctoredBy(DName,PName,LastCheckDate)

Sql query to find the Name of Doctor who has checked maximum patients?

"select max(count(Pname)) from isdoctoredby group by Dname" this query
gives maximum value but I want the Dname too.
"select DName, max(count(Pname)) from isdoctoredby group by Dname" gives
error!!

Thanks in advance.
With regards,
Rohit

 

[Van T. Dinh]

Use one of the techniques described in The Access Web
article:

<http://www.mvps.org/access/queries/qry0020.htm>

HTH
Van T. Dinh
MVP (Access)

 

[Van T. Dinh]

Try: (***untested***)

SELECT TOP 1 IDB.DName, Count(IDB.PName)
FROM IsDoctoredBy AS IDB
GROUP BY IDB.DName
ORDER BY Count(IDB.PName) DESC

(I assumed DName is uniquely indexed, i.e. DName uniquely identifies the
Doctor)