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 is the clustering index in the db2 database?

682


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

783


What is the difference between drop table and delete table?

685


How to create backup table in db2?

762


My sql statement select avg(salary) from emp yields inaccurate results. Why?

771






How does a cursor work?

660


What is the role of schema in the db2 database?

810


How to find primary key of a table in db2?

750


What is syscat in db2?

693


Give the name of some fields form sqlca.

738


What is node in db2?

721


What is dbrm?

777


Why select is not preferred in embedded sql programs?

852


What do you mean by commit and rollback?

716


What is cloudant database?

750