Tuesday, 10 September 2013

SQL query error: select number of rows from table

SQL query error: select number of rows from table

I have a SQL query, basically I am trying to select a certain amounts of
rows starting at an index with some basic criteria. My sql skills are
average and I keep getting a missing expression error when I run this:
select * from content.documents
where [source] in ('SEC', 'NA-SEC', null)
and state in ('new', 'draft', 'active')
and [type]='general-doc';
and rownum > 10
limit 10;
order by [date] desc;
Thanks in advance to anyone who can point out where I am going wrong!

No comments:

Post a Comment