Home » RDBMS Server » Server Administration » Re: Returning 2 values with Max function
Re: Returning 2 values with Max function [message #370806] Thu, 10 February 2000 06:44
Rehman
Messages: 19
Registered: February 2000
Junior Member
Select Month_Name, Sales_Amt From Table_name where (Month_Name,Sales_Amt) in (Select Month_Name,Max(Sales_Amt) From Table_Name Group By Month_Name) Order By Month_Name Desc;

Regards
Atavur
Previous Topic: Returning 2 values with Max function
Next Topic: How can I replace standard Oracle messages...
Goto Forum:
  


Current Time: Thu Mar 28 09:54:04 CDT 2024