Home » RDBMS Server » Server Administration » Returning 2 values with Max function (New One)
Returning 2 values with Max function (New One) [message #370818] Fri, 11 February 2000 00:12
Atavur Rahaman S.A
Messages: 23
Registered: January 2000
Junior Member
Hello,
I think what U want is this query.....

SQL> Select Dept_Id,Month_Name,Amount From
Table_Name Where(Dept_id,Amount) in (Select Dept_id,Max(Amount) From Table_Name Group By Dept_id)

Regards
Rehman
Previous Topic: Crosstab query??
Next Topic: Cumulative value
Goto Forum:
  


Current Time: Sat Oct 24 03:53:36 CDT 2020