top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

How will you get 21 to 30 record from 50 records?

0 votes
83 views
How will you get 21 to 30 record from 50 records?
posted Oct 9, 2015 by Sunil

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

select * from table where rownum<=30

minus

select * from table where rownum<=21;

Other than the above ans:

Using sequence generator, expression and filter transformation
OR

Using mapping variable initialised to zero, expression and filter transformation.

answer Oct 9, 2015 by Manikandan J
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...