select S.field1,S.field2 from (select field1,field2 from table where field1>26 and field1<30 ) S where S.field1<=27 order by S.field1 asc
* means group of values in your tables.so inline subquery are not handled it .so wanted field only implemented in inline sun query and assigned