Select Accountno, MAX(Amtpayable) from Accountpayale Group by Accountno Order by accountnoBut when I triied this it gave me "Error Order By Clause is Invalid"
Select Accountno, MAX(Amtpayable) from Accountpayale Group by Accountno Order by AmtpayableSo in the above case If I need data in Order of Amount payable, what should I do ?