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

Describe different types of general function used in sql?

725

What is a relationship and what are they?

779

What is the difference between instead of trigger and after trigger?

694

What is the execution plan in sql?

755

What are inbuilt functions in sql?

793

How to create a menu in sqlplus or pl/sql?

807

What is a sql profiler?

769

what happens if you no create privilege in a database? : Sql dba

713

Can two tables have same primary key?

728

explain the delete statements in sql

745

What are some predefined exceptions in pl/sql?

741

Which table is left in left join?

714

What is meaning of <> in sql?

794

what is the command used to fetch first 5 characters of the string? : Sql dba

1365

What does pl sql stand for?

849