Excel SQL - Where clause incorect syntax

Question

I have a table in Excel and I want to query Column J which in the table is called Questions for words matching some conditions.

So I have tried this syntax

Select * from TSO.RawData   where trademthstart > dateadd(month,-6,GETDATE())  order by row_date asc  WHERE Questions LIKE '%NRM%'

However I get an error near where clause

huudooguuruu · Accepted Answer · 2016-05-04 01:10:36Z

1

Try this:

Select * from TSO.RawData   
where trademthstart > dateadd(month,-6,GETDATE())  
and Questions LIKE '%NRM%'
order by row_date asc

Seems the "order by row_date" should be placed after the filters (where, and). After Where, any other filters should start with AND.

answered May 4, 2016 at 1:03

huudooguuruu

263 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1