How One can easily select all even, odd, or Nth rows from a
table using SQL queries?
- 4 Answers
- 19073 Views
- I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
How do I view tables in mysql?
what is the difference difference between procedure and packages
What is package in pl sql with an examples?
What is the difference between row level and statement level trigger?
How do I get sql certification?
Why is normalization important?
What are different types of sql?
What is normalisation in sql?
What is bulk compiling in pl/sql.?
What are types of indexes in sql?
How do I run a script in sql developer?
What is cursor and why it is required?
what is denormalization. : Sql dba
How do I view an execution plan in sql?
How insert into statements in sql?
