Sublime Text 2select * from ( select rownum as rn, type from t_table where rownum <= 7) where rn >= 3;
RN TYPE
3 ADD
4REMOVE
5ADD_TO
6DUPLICATE
7NEW
select rowid as id, type from t_table;
ID TYPE
AAAE6sAABAAALpiAAGADD
AAAE6sAABAAALpiAAEADD_TO
AAAE6sAABAAALpiAAFADD
AAAE6sAABAAALpiAAHREMOVE
AAAE6sAABAAALpiAABADD_TO
AAAE6sAABAAALpiAACDUPLICATE
AAAE6sAABAAALpiAAANEW
A good tool:
Sublime Text 2
