Select ... FROM ... WHERE ... FETCH FIRST 1 ROW ONLY

query to just fetch first matching row and stop execution.
once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

Question Posted / romeu viegas

2 Answers
5420 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / romeu viegas

Select ...
FROM ...
WHERE ...
FETCH FIRST 1 ROW ONLY

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I add a column to an existing table in db2?

976

What is the difference between nvl and coalesce?

1009

What is a db2 cursor?

1004

What is the max length of sqlca?

1157

What is dclgen in db2?

1082

When the like statement is used?

1156

What are db2 tables?

1049

What is data manager?

993

What is dpf in db2?

1047

What is database manager in db2?

966

What is db2?

1124

What is ibm db2 database?

951

What is table space in db2?

959

What is db2 look?

970

How can deadlocks be resolved?

889