```
SELECT orderid 
 FROM (SELECT orderid, rownum r 
         FROM (SELECT orderid 
                 FROM myorders 
                WHERE ordertype = 'E' 
                  AND orderstatus = 'A') a 
         WHERE rownum < 86) 
 WHERE r > 84

```

What is the best way to rewrite the ABOVE sql statement in more clear way...

I have tried the following but I am not getting any results. 

```
select orderid 
  from myorders 
 where rownum between 84 and 86

```