Question

1. In SQL, name the aggregate function that returns the number of records in a
table.​

Answer 1

Answer:

kqkkqkkqklqllqllqkjjqjjqjjqjjqj

Answer 2

Answer:

The aggregate function is THE COUNT FUNCTION

The COUNT FUNCTION returns the number of records in a table in SQL

Explanation:

SQL aggregate function is used to perform calculation on multiple rows of a single column of a table and it also returns a single value. The SQL aggregate function is also used to summarize the data

The COUNT Function it is used to return a number of rows in a specified table or view that includes the number of duplicate and Null value.

COUNT FUNCTION It is also used to count number of elements in group defined.

OTHER TYPES OF SQL AGGREGATE FUNCTION.

Apart from COUNT Function there are other aggregate function in SQL and they include

1. SUM - it is used to calculate the sum of given attributes/expression in group defined.

2. AVG - This aggregate function calculates the average value of the given expression in group defined.

3. MIN - This aggregate Function finds the minimum value in group defined.

4. MAX - It is used to find the maximum value in the group defined.