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
5435 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

What is db2 plan table?

1003

What do you mean by cursor?

950

What are the various isolation levels possible?

1057

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1112

What are packages in db2?

982

How to fetch the last row from the table in SQL (db2)?

1596

What is cursor with hold option in db2?

1021

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1239

What is the use of db2?

1013

What is difference between rollback and commit?

1104

What is cascading rollback?

1141

Who uses db2?

988

How do I copy a table in db2?

959

How does coalesce work?

968

How can deadlocks be resolved?

899