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

What are the Abstract Classes provided by Java?

5 Answers   Oracle,


What is prefix of a string?

0 Answers  


What is the difference between jdk, jre, and jvm?

0 Answers  


Explain method overloading and overriding?

6 Answers  


What classes can be used to store arbitrary number of objects ?

1 Answers  






How we can execute any code even before main method?

0 Answers  


What is the ==?

0 Answers  


How many threads does a core java have?

0 Answers  


In which order the iterator iterates over collection?

0 Answers  


Difference between nested and inner classes ?

0 Answers  


What is the new line character?

0 Answers  


In how many ways we can do synchronization in java?

0 Answers  


Categories