Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to select only the second row in a query

Rhine23Oct 26 2017 — edited Oct 31 2017

Hi Guys,

Please would you be able to help me with this one. I have the below query

SELECT SURNAME, INITIALS, RELATIONSHIP_TO_HH, MEMBER_TYPE FROM SOUT.MEMBERS

WHERE SURVEY_ID = '1000000040' AND MEMBER_TYPE NOT IN ('1','2')

which returns the below

mem2.PNG

How can I write a query that will only display the second row and not the first. The thing is that I have to display 2 family members in a form that are on two separate lines and sometimes there are more then two member as above

So i was thinking to use the above select to get the first row

Then I would use another select to skip the first row and only display the second row.

Please advise. Thank you kindly
This post has been answered by Frank Kulash on Oct 26 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 28 2017
Added on Oct 26 2017
16 comments
19,062 views