SIMPLE ODD AND EVEN... SQL> SELECT ROWNUM FROM EMP GROUP BY ROWNUM HA

How One can easily select all even, odd, or Nth rows from a
table using SQL queries?

Question Posted / mahesh

4 Answers
20194 Views
I also Faced
E-Mail Answers

Answer Posted / mahesh

SIMPLE ODD AND EVEN...

SQL> SELECT ROWNUM FROM EMP GROUP BY ROWNUM HAVING MOD(ROWNUM,2)=1
2 /

ROWNUM
----------
1
3
5

1* SELECT ROWNUM FROM EMP GROUP BY ROWNUM HAVING MOD(ROWNUM,2)=0
2 /

ROWNUM
----------
2
4
Goahead...

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does trigger mean in slang?

1050

define sql delete statement ? : Sql dba

1015

Is like operator in sql case sensitive?

1022

What is rank dense_rank and partition in sql?

1037

Differentiate pl/sql and sql?

1064

what is the bond code in materialized view?

3002

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

956

How do I run a pl sql program?

1128

Is inner join faster than left join?

1190

Why select is used in sql?

1017

Explain the difference between sql and mysql.

1060

What are all the common sql functions?

1023

What is count * in sql?

993

What are all the different normalization?

1037

What is int identity in sql?

1137