when u use column function without using group by clause. it will give only

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

Question Posted / shekhar

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

Please Help Members By Posting Answers For Below Questions

What is buffer pool and list some of them?

992

What is declare cursor?

1055

Explain in detail about buffer manager and its functionalities?

1010

Is it possible using max on a char column?

1092

How can we retrieve the total number of records in RPG & CLLE?

590

List out the three types of page locks that can be held.

1103

How does coalesce work?

970

How to find the maximum value in a column in the db2 database?

1030

Mention data types used in db2 ?

1115

What is the use of with ur in db2?

1009

How do I delete a table in db2?

1018

What is dclgen in db2?

1091

What is the physical storage length of timestamp data type?

1035

What is the advantage in De-normalizing tables in DB2?

1127

Is db2 a mainframe?

986