Simple Query Help

What is wrong with this query?

select * from (select a from tablename where b = 1 order by ts desc) where rownum < 100

I get a ORA-0097: missing right parenthesis.

This works just fine however (but not what i want)

select * from (select a from tablename where b = 1) where rownum < 100

Is there an easier way or a work around?

---
Gabriel Millerd   |       Let them hate, so long as they fear.  -Lucius
Sith Admin        |                      Accius, Fragment
http://sabbat.org |