It displays odd rows select * from emp where (rowid,0) in(select rowid,mod

how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me

Question Posted / jhansi

Answer Posted / jhansi

It displays odd rows
select * from emp where (rowid,0) in(select rowid,mod
(rownum,2) from emp);

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Can we create a node as a gateway node and the same node can be assigned to a grid?

1069

Explain Dataware house architecture .how data flow from intial to end?

2575

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2323

Explain load alternative records / rows into multiple targets - informatica

1137

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2125

Explain incremental aggregation in informatica

1112

What is xml source qualifier transformation in informatica?

1207

How do you load first and last records into target table?

1144

Tell me about MD5 functions in informatica

919

Define pmcmd command?

1029

Which means the first record should come as last record and last record should come as first record and load into the target file?

1061

What are the modules in Power Center

1669

Separate from an archive server and a powerhouse?

947

What is a code page?

1161

What is a dimensional model?

967