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 user defined exceptions?

0 Answers  


How do you call a reference in java?

0 Answers  


Difference between predicate, supplier and consumer ?

0 Answers  


What do you mean by thread safe?

0 Answers  


Tell us something about set interface.

0 Answers  






i don't want fullforms of JDK an JVM i want definitions for them

2 Answers  


Why declare Main() method as a static in java ?

0 Answers   HCL,


What are java threads?

0 Answers  


How to print a statement without using semicolan in java

6 Answers   HCL, IBM,


What is palindrome in java?

0 Answers  


how to write a program for sending mails between client and server

0 Answers   Lampex,


What are the main differences between notify and notifyAll in Java?

0 Answers  


Categories