>I have trying to retreive Data from a Table. The said Table has account Number and Amout Payable as Fileds.
>
>The same Account Number can have many amount payable so I am trying to extract Account number wise Highest Value of Amount payable.
>
>I tried this and it worked fine.
>
>
>Select Accountno, MAX(Amtpayable) from Accountpayale Group by Accountno Order by accountno
>
>
>But when I triied this it gave me "Error Order By Clause is Invalid"
>
>Select Accountno, MAX(Amtpayable) from Accountpayale Group by Accountno Order by Amtpayable
>
>
> So in the above case If I need data in Order of Amount payable, what should I do ?
You need to give an alias to your computed column and add that alias in the ORDER BY, e.g.
Select Accountno, MAX(Amtpayable) AS MaxAmtPay from Accountpayale Group by Accountno Order by MaxAmtPay
If it's not broken, fix it until it is.
My Blog