SELECT * FROM emp WHERE (ROWID,0) IN (SELECT ROWID, MOD(ROWN

How One can easily select all even, odd, or Nth rows from a
table using SQL queries?

Question Posted / guru

Answer Posted / guru

SELECT *
FROM emp
WHERE (ROWID,0) IN (SELECT ROWID, MOD(ROWNUM,4)
FROM emp);

Is This Answer Correct ?

6 Yes

17 No

Please Help Members By Posting Answers For Below Questions

Can you rollback after commit?

995

How many aggregate functions are available there in sql?

988

What is the non-clustered index in sql?

1066

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

1003

How do I create a sql script?

1105

Is sql injection illegal?

1030

What is bulk compiling in pl/sql.?

1136

What is pl sql script?

1036

What is character functions?

1066

What do you know by pl/sql cursors?

1109

what are numeric data types? : Sql dba

1065

Show the two pl/sql cursor exceptions.

1201

What is the difference between left and left outer join?

950

does sql support programming? : Sql dba

1052

Which is better trigger or stored procedure?

955