Hi,

you could proceed as follows:

1.) alter table scott.emp by adding a new column

new_col | empno| job...
--------------------------
| 7566| Manager..............

2.) update emp by inserting 1,2,...in this new column.

new_col | empno| job...
--------------------------
1 | 7566| Manager..............
2 | 7590| Clark..............
...

3.) select * from scott.emp where MOD(new_col,2) != 0;

...this returns the rows where the numbers in new_col modulo 2 are not 0, i.e. the odd rows.


Cheers,
Dan1