When Can you be sure that a query will return only one row?

Answer Posted / shekhar

when u use column function without using group by clause. it will give only single value. PLz correct if i m wrong.

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can deadlocks be resolved?

720


How do I add a column in db2?

768


What is dbrm in db2 database?

782


What is the cobol picture clause of the db2 data types date, time, timestamp?

831


Is ibm db2 free?

750


What is explain plan in db2?

765


What is the maximum size of a char data type in db2?

767


What is db2 and what is the use of db2 optimizer?

826


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2001


Why select is not preferred in embedded sql programs?

922


Which component is responsible for processing sql statements and selecting access paths?

886


What is cursor in dbms?

815


What is meant by explain?

841


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

789


What is null value in db2?

750