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

How to synchronize 2 schema's objects?

0 Answers   Virtusa,

---

How to write a query with a right outer join in oracle?

0 Answers  

---

1.display list of all users from ur data base.what is the query?

3 Answers   CGI, IBM,

---

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

3 Answers   Amazon, HCL,

---

24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.

2 Answers   Wipro,

---

Is it possible to insert comments into sql statements return in the data model editor ?

0 Answers   Oracle,

---

I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????

1 Answers  

---

What is an Oracle view?

1 Answers  

---

SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?

1 Answers   ESS,

---

which is the best training centre for learning oracle?

13 Answers  

---

Without giving condition how to retrieve the unmatched records from table.

1 Answers   TCS,

---

what are pseudocolumns?

4 Answers  

---