Answer / Madhu

"SQL provides several aggregate functions to perform calculations on a set of data. Some common ones include COUNT, SUM, AVG (average), MIN (minimum), and MAX (maximum). These functions can be used in SELECT statements to calculate the total number of rows, sum of values, average value, minimum value, or maximum value of a column."n

what is an associative array with example?

1 Answers  

---

what is online transaction processing (oltp)? : Sql dba

1 Answers  

---

List the various privileges that a user can grant to another user?

1 Answers  

---

Why coalesce is used in sql?

1 Answers  

---

What is a database trigger?

1 Answers  

---

How to add a column ‘salary’ to a table employee_details?

1 Answers  

---

What are the benefits of pl/sql packages?

1 Answers  

---

I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

15 Answers   Wipro,

---

What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.

3 Answers   TCS,

---

What is nosql db?

1 Answers  

---

What is hibernate and its relation to sql?

1 Answers  

---

What is execution plan in sql?

1 Answers  

---