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

How we get some middle records in one table?

Question Posted / meena

2 Answers
6347 Views
3i Infotech, I also Faced
E-Mail Answers

Answer Posted / meena

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

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is difference overloading and overriding?

1161

Do I need java on my pc?

1042

A non-static inner class may have object instances that are associated with instances of the class’s outer class. A static inner class does not have any object instances.

1014

What do you mean by collectors in java 8?

930

What are the features of junit?

1041

What is the benefit of abstract class?

944

FOR EXAMPLE WE R HAVING TWO LIST ELEMENTS ..BOTH LISTS CONTAINS ID,NAME,PLACE ..I NEED TO COMPARE BOTH IDS IN TWO LISTS,IF ID'S R SAME MEANS WE HAVE ADD THE DETAILS(LIKE NAME,PLACE) TO MAP...HOW IS POSSIBLE ?CAN ANY ONE SUGGEST?

3468

Explain why wait(), notify() and notifyall() methods are in object class rather than in thread class?

1007

How can we make a class virtual?

1110

Explain about the performance aspects of core java?

1053

When do we use hashset over treeset?

1053

What is another word for methodology?

1013

Which class is the superclass for every class in java programming?

994

When will you define a method as static in Java?

1055

Is boolean a wrapper class in java?

1052