1.

How to retrieve the current version of a MySQL?

Answer»

You can use this query in your phpmyadmin SELECT version();

44. What are aggregate functions in MySQL?

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 provides many aggregate functions that are listed below.

  • AVG()
  • COUNT()
  • SUM()
  • MIN()
  • MAX() etc


Discussion

No Comment Found

Related InterviewSolutions