How we get some middle records in one table?

Question Posted / javahelper

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

More Core Java Interview Questions

Can we serialize static variables in java?

Which one of the following suits the description of a string better: derived or primitive?

What is variable explain?

What is difference between pointer and reference?

What is difference between path and classpath variables?

class A { private int i; } class B extends A { private int i; } if I create an object of B class what will be the memory of that object.

How does JAVA ClassLoader work?

why marker interfaces are there in java

can we have virtual functions in java?

What is method Overloading in the perspective of OOPS?

Name the components that are termed to be Heavy-weight component but available in Light-weight components?

Where is const variable stored?

For more Core Java Interview Questions Click Here