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

What is a field in a database?

1005

---

How does pl sql work?

913

---

Is inner join same as self join?

1060

---

What is sql injection owasp?

999

---

Are views faster than queries?

917

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

3925

---

What is the difference between database trigger and stored procedure?

1007

---

What is pl sql variable?

936

---

What are the different types of a subquery?

981

---

How do I start sql profiler?

941

---

What is clause in sql?

1053

---

what are the differences among rownum, rank and dense_rank? : Sql dba

981

---

is it possible to pass an object or table to a procedure as an argument?

1059

---

Is time a data type in sql?

852

---

write an sql query to find names of employee start with 'a'? : Sql dba

965

---