Saturday 18 June 2011

How to display alternative rows in a table ?

SQL> select *from emp where (rowid, 0) in (select rowid,mod(rownum,2) from emp);

No comments:

Post a Comment