SQL aggregate functions return a single value, calculated from values in a

Do you know about aggregate functions? What is row num function? Can it be used all databases?

Question Posted / nilam

1 Answers
4398 Views
Bravura Solutions, Cap Gemini, I also Faced
E-Mail Answers

Answer Posted / nilam

SQL aggregate functions return a single value, calculated from values in a column.

Useful aggregate functions:

AVG() - Returns the average value
COUNT() - Returns the number of rows
FIRST() - Returns the first value
LAST() - Returns the last value
MAX() - Returns the largest value
MIN() - Returns the smallest value
SUM() - Returns the sum

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between post-database commit and post-form commit?

1105

Please explain compound trigger in oracle?

993

How to set up autotrace for a user account?

971

Is it possible to split the print reviewer into more than one region ?

2221

How to use subqueries with the exists operator in oracle?

968

What are the roles of dba?

1018

What is a package ? What are the advantages of package ?

1033

Why cursor variables are easier to use than cursors?

1019

Write a trigger example in oracle?

980

What is oracle thin client?

972

What is MTTR advisor in Oracle?

1033

What is connection pooling in oracle?

911

Explain the use of full option in exp command.

1054

What is truncate oracle?

915

What is the difference between I and G in Oracle?

1017