Aggregate Function : Which returns one row for a group. Analytical Funct

Difference between aggregate function and analytical function?

Question Posted / nb_mopidevi

3 Answers
31555 Views
Metric Stream, I also Faced
E-Mail Answers

Answer Posted / nb_mopidevi

Aggregate Function : Which returns one row for a group.

Analytical Function : which returns one result for each row in the group.

feedback accepted.

Is This Answer Correct ?

60 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is cursor in pl sql?

1181

How to create an array in pl/sql?

1115

List and explain the different types of join clauses supported in ansi-standard sql?

1400

Is join an inner join?

1020

What are field types?

1049

What is mdf ldf and ndf?

1055

What are different clauses used in sql?

1169

What is varchar data type in sql?

1133

what is oracle database ? : Sql dba

1076

define data blocks ? : Sql dba

1040

What is Histogram?

1607

What is multiple columns?

1113

What is composite data type in pl sql?

1165

What is sequence in sql?

1074

What does count (*) do in sql?

1047