MVSFORUMS.com

nadh · Intermediate Joined: 08 Oct 2004 Posts: 192 Topics: 89

Hi,

I have a table of 100 rows. How to fetch only the first two rows using the select statement. I should not use any functions like count(*). there is no any condition to fetch rows. it is simple select statment.

pls. help me out.

Thanks in advance
nadh

schintala · Posted: Thu May 26, 2005 7:58 am Post subject:

Did you try using the clause FETCH FIRST 2 ROWS ONLY in select statement. I guess it works. Try it out.

kolusu · Posted: Thu May 26, 2005 8:08 am Post subject:

nadh,

*sigh* ! you are on route to loose your privileges to post on this board.

http://mvsforums.com/helpboards/viewtopic.php?t=443&highlight=fetch+first

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

nadh · Intermediate Joined: 08 Oct 2004 Posts: 192 Topics: 89

Kolusu,

Thankyou.

But, I know with FETCH FIRST 2 ROWS ONLY it works. But i want to retrieve the first two rows without using FETCH statement in SELECT. I should not use even count(*). Without using these things Is there any way to get first 2 rows from table? I can use subqueries.

Thanks in advance.
nadh

kolusu · Posted: Fri May 27, 2005 7:21 am Post subject:

nadh,

Can you tell me the reason as to why there are so many restrictions to just fetch 2 rows? Is this an interview question? If it was a real requirement, then please enlighten me as to why you cannot use fetch first clause with select or even count(*) function.

If this is indeed an interview question then here is the answer.

In spufi you have the option of setting the max select rows.