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

What does db2 blu stand for?

887


What is syscat in db2?

780


What language is db2 written in?

789


Explain dclgen.

938


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

989


Explain how can you do the explain of a dynamic sql statement?

854


What is the difference between dbm cfg and db cfg file in db2 ?

1267


What is precompiler in db2?

769


What is the role of the data page in the db2 database?

784


How do I change the column size in db2?

855


What is universal database?

833


How is deadlock resolved?

839


When the like statement is used?

886


Why select is not preferred in embedded sql programs?

947


What is dclgen (declaration generator)?

819