How we get some middle records in one table?

Answers were Sorted based on User's Feedback



How we get some middle records in one table?..

Answer / meena

select * from emp where rownum=(select mod(rownum,2) from emp);

Is This Answer Correct ?    1 Yes 1 No

How we get some middle records in one table?..

Answer / prasanna

By using a search condition like 'where'

Eg:select eno,ename,esal from emp where eno=3;

Is This Answer Correct ?    2 Yes 4 No

Post New Answer

More Core Java Interview Questions

which is advanced deep technology in java launched by the sun microsystem??? The answer is very logical If u need correct answer mail me at priya_gupta@gmail.com

0 Answers   IBM,


Is array an object in java?

0 Answers  


Can a java program have 2 main methods?

0 Answers  


What do you mean by stack?

0 Answers   Accenture,


What are access specifiers in java ?

0 Answers   Akamai Technologies,






What is the purpose of the System class?

0 Answers  


What are the advantages of passing this into a method instead of the current class object itself?

0 Answers  


What are the features of junit?

0 Answers  


Can we override private method?

0 Answers  


How does a for loop work java?

0 Answers  


What is foreach loop in java?

0 Answers  


State one difference between a template class and class template.

0 Answers   HAL,


Categories