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 sql injection vulnerability?

1005

What are commit, rollback, and savepoint?

1047

How exception handling is done in advance pl/sql?

1022

what is data integrity? : Sql dba

1086

How do I make my sql query run faster?

1016

What is a ddl command?

1154

What is difference between procedure and trigger?

1020

Which is better cte or subquery?

1076

Can two tables have same primary key?

1023

What is java sql connection?

1120

what is sp_pkeys? : Transact sql

1203

Can a composite key be null?

1031

how to calculate expressions with sql statements? : Sql dba

1094

What is the purpose of using pl/sql?

1189

What is localdb mssqllocaldb?

1106