Difference between aggregate function and analytical function?

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

Write a query to find the names of users that begin with "um" in sql?

505


How to call a javascript function from pl sql?

565


How do I run pl sql in sql developer?

630


What is informix sql?

540


What are the types of queries in sql?

524






what are the authentication modes in sql server? : Sql dba

535


Explain what is table in a database?

580


What is sql key?

525


How to combine two stored procedures in sql?

593


What is the difference between microsoft access and sql?

500


How do I truncate a sql log file?

540


what are wild cards used in database for pattern matching ? : Sql dba

550


How do you update a table in sql?

519


Is it possible to include an insert statement on the same table to which the trigger is assigned?

561


Which is faster subquery or join?

662