Answer / 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.

Answer / yogish naik

we can observe that the aggregate functions return only one
row per group whereas analytic functions keeps all the rows
in the group. Using the aggregate functions, the select
clause contains only the columns specified in group by
clause and aggregate functions whereas in analytic functions
you can specify all the columns in the table.

The PARTITION BY clause is similar to GROUP By clause, it
specifies the window of rows that the analytic funciton
should operate on.

Answer / pradeep

aggregate function - it returns only single value and (aggr Fun are Min,Max,Count,Sum,Avg)
analytical Function - it returns more than one value and (Analy fun are, string,date, numeric,conversions, and miscellaneous)

what is the difference between a local and a global temporary table? : Sql dba

0 Answers  

---

Which is faster union or join?

0 Answers  

---

What are the default Oracle triggers??

3 Answers   CGI, Tech Mahindra,

---

is it mandatory to select all the column in a view then what columns should be selected

2 Answers  

---

How do sql databases work?

0 Answers  

---

---

what is the output of this query selet * from employee where 1=2 ??

11 Answers  

---

What is trigger and types?

0 Answers  

---

What is right join sql?

0 Answers  

---

how to extract a unit value from a date and time? : Sql dba

0 Answers  

---

how are mysql timestamps seen to a user? : Sql dba

0 Answers  

---

i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?

6 Answers   Fidelity, IBM,

---

What is identity column in sql server?

0 Answers  

---