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

Write a query to find the names of users that begin with "um" in sql?

926

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1074

what is the difference between primary key and unique key? : Sql dba

972

How many types of sql are there?

930

Can we perform dml on view?

976

Can one improve the performance of sql*loader? : aql loader

983

What is data control language?

949

How do I edit a stored procedure?

949

What is a natural join?

992

how to convert numeric values to character strings? : Sql dba

1037

Which constraints we can use while creating database in sql?

1018

How do you use join?

890

What is Difference Between Unique and Primary Key Constraints?

1060

What are the syntax and use of the coalesce function?

1105

what are null values? : Sql dba

902