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
5516 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 are the contents of a dclmgen?

1120

What does a deadlock mean in DB2?

1158

How do I delete a table in db2?

1059

Is db2 a programming language?

1040

What is explain plan in db2?

981

What is the physical storage length of time data type?

1119

What is the physical storage length of timestamp data type?

1086

How many databases are there?

1048

What is dclgen (declaration generator)?

1049

What is the default page size of buffer pools?

1120

What is a bind card?

1212

How do I create a view in db2?

1015

What type of database is db2?

962

What is the difference between using bind () and rebind () methods of naming class?

1387

Is db2 relational database?

971