How to solve this error?

Question

This is the query for sorting date.It works fine but when i adding where condition it throws error..

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

Error:
Incorrect syntax near the keyword 'Where'.

Can any one help me out..

Biswa Pujarini Mohapatra · Answer

where clause should come before Order by select date1 from (select distinct convert(varcharconvert(datetimeDate105)103) as date1convert(datetimeDate103)as date2 from Tyre_StockEntry) g Where Brand='Apollo' and Pattern='Sedan' order by convert(datetimeconvert(varchardate12)103) desc hope it helps

Jignesh Trivedi · Answer

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 kumar · Answer

Thanks for your reply...I found the answer.. select date1 from (select distinct convert(varcharconvert(datetimeDate105)103) as date1convert(datetimeDate103)as date2 from Tyre_StockEntry Where Brand='Apollo' and Pattern='Sedan') g order by convert(datetimeconvert(varchardate12)103) desc