AdRock Posted November 17, 2007 Share Posted November 17, 2007 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 Quote Link to comment https://forums.phpfreaks.com/topic/77726-solved-using-max-to-find-the-name-of-the-highest-budget/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.