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

What are the two types of periodical indexes?

925

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1042

what is rollback? : Sql dba

1081

How do I enable sql encryption?

1007

Is it possible to sort a column using a column alias?

1026

What are the advantages of sql?

1038

How do I partition in sql?

944

how many tables will create when we create table, what are they? : Sql dba

1053

How can we find duplicate records in a table?

927

What is scalar function?

1034

How to use sql*plus built-in timers?

1171

What is record variable?

961

What are pl/sql cursors?

1037

Can I create table without primary key?

982

What is hibernate and its relation to sql?

1101