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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Feb 12 20:23:34 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.