Answer Posted / hrindows@gmail.com

The MySQL aggregate function performs a calculation on a set of values, and it returns a single value as output. It ignores NULL values when it performs calculation except for the COUNT function.
MYSQL Aggregrate functions are listed below:
 AVG()
 COUNT()
 SUM()
 MIN()
 MAX()

What is the query to display top 20 rows?

612

---

What does blob mean in mysql?

494

---

Write a command to view mysql database table structure?

535

---

How to display nth highest salary from a table in a mysql query?

543

---

What is mysql connector used for?

519

---

---

How do I optimize a selected query in mysql?

514

---

What is not null in mysql?

516

---

What are the mysql database files stored in system ?

507

---

Explain the architecture models of SQL Server?

1902

---

How to drop an existing index in mysql?

555

---

What is mysql procedure?

511

---

How do you use auto increment?

516

---

How we get sum of column.

509

---

How many mysql connections can handle?

490

---

How can I create a database in mysql?

472

---