How to solve this error?

Hi,

Good you got the solution of your problem but why you convert your filed two time in order by clause?
it will degrade your query performance as well as query may give you wrong order.

selva kumar12y ago

Thanks for your reply...I found the answer..

select date1 from (select distinct convert(varchar,convert(datetime,Date,105),103) as date1,convert(datetime,Date,103)as date2 from Tyre_StockEntry Where Brand='Apollo' and Pattern='Sedan') g order by convert(datetime,convert(varchar,date1,2),103) desc

Biswa Pujarini Mohapatra12y ago

where clause should come before Order by

select date1 from (select distinct convert(varchar,convert(datetime,Date,105),103) as date1,convert(datetime,Date,103)as date2 from Tyre_StockEntry) g

Where Brand='Apollo' and Pattern='Sedan' order by convert(datetime,convert(varchar,date1,2),103) desc

hope it helps