Dear All,
I am trying to execute a sub-query and it has multiple records but I want just one record for it. What is it's way.

I am thankful to you all who will trying to help me.

Yours,
Ali

You query is wrong. (Maybe if you post the query and what you want it to do you would get a better answer).

Andy

Select a.name from A a
where
exist (select dept from Dept where dept_loc like 'N%')

The sub-query has 200,000 records and I just want to limited it as if it return 200,000 record it just check if one is exist then it return true result rather it check all the 200000 records.

With the exists your subquery is not getting all 200K records, just the first one. Though with the query you show, you will get every row from table A, if a row does exist in your subquery.
Dave

You can add the FETCH FIRST 1 ROW ONLY clause to the subquery.


Andy

In sub-Query Fetch First 1Rows Only not allowed.

What platform and DB2 version/release are you using?

By referencing manuals, fetch-first-clause in subquery was supported from
DB2 Universal Database(for LUW) Version 8,
DB2 Version 9.1 for z/OS,
and
DB2 for i Version 6 Release 1.

You can use ROW_NUM function

Dave must be completely right.

My guess is that there might be some relationship between A and Dept,
something like...