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

What is java virtual machine? Explain

What is the final keyword denotes?

What is the difference between interpreter and compiling ?

what is difference between type 4 driver and type 1 driver?

If you are reviewing the code of your team members, what points will you look at, assuming the performance of the application is not so great

What are voids?

Can we pass a primitive type by reference in java? How

What are event-delegation model and event-inheritance model? Which is best?

Why is string class considered immutable?

What is string args [] in java?

Why main function is static?

List primitive java types?

For more Core Java Interview Questions Click Here