[SOLVED] Using MAX to find the name of the highest budget

[AdRock]

Can someone please help me with this query

 

I am trying to find the name of the department with the highest budget but all i am getting is each department with their budget.  Is there a way i can display just name of the department with the highest department?

 

SELECT MAX(budget) as budget, dname FROM Department GROUP BY dname;

 

What it displays is:

 

200000      Purchasing

30000        Personnel

150000      Finance

50000        Sales

500000      Toy

 

and what i want it to display is

500000      Toy