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

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1077

What is db2 purescale?

1006

How to find schema of a table in db2?

1016

What is a db2 schema?

1234

What is the advantage in De-normalizing tables in DB2?

1181

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1092

What is the connection string to connect to the DB2 Database ?

1128

What does sqlcabc has?

1058

How to access db2 tables in mainframe?

1055

What is a bind card?

1218

What do you mean by cursor?

988

What are the rules for db2 programming?

1090

What is difference between rollback and commit?

1164

Discuss about db2 bind?

1098

Explain about rct in db2?

1109