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 is a unique key and primary key and foreign key?

914

What are different types of sql?

1092

What is normalization? How many normalization forms are there?

1009

Explain correlated query work?

986

what is log shipping? : Sql dba

1055

What is the difference between database trigger and stored procedure?

1003

what is the difference between char_length and length? : Sql dba

988

What is a database? Explain

1049

what is a constraint? : Sql dba

1099

what is the difference between myisam static and myisam dynamic? : Sql dba

1001

What are the three pl sql block types?

945

How to add, remove, modify users using sql?

977

Which is faster union or join?

898

Which data dictionary views have the information on the triggers that are available in the database?

1179

What is a schema? How is it useful in sql servers?

1037