TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
selva kumar
NA
557
189k
How to solve this error?
Feb 22 2014 6:03 AM
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..
Reply
Answers (
3
)
Insert Values in Four Tables at a time
self joining