Thanks You


>>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