11 using SQL statements in ASP: record statistics

It is not difficult to determine how many records exist in the database or determine how many records meet certain standards. If you use the correct cursor type, you can use the RecordCount attribute to obtain the number of records. Of course, you can also use recordset. However, there is a simpler way to use count (*) in your SELECT statement. The code is as follows:
SQL = "SELECT count (*) FROM MERS"
Or
SQL = "SELECT count (*) FROM MERS WHERE c_lastname LIKE 'a % '"
For example, the following code selects some records and the total number of these records:
SQL = "SELECT c_firstname, c_lastname, count (*) FROM MERS WHERE c_lastname LIKE 'a % '"
However, you cannot achieve your goals. Here, the "count" function is actually a set function, meaning that only the single row information is returned: To answer your question. The question for the 1st SELECT statements is "how many records are there in the customer table ?" The query returns a single value as a response, so it cannot be combined with your regular query. If you want to get other data, you need to use RecordCount.
In addition to "count", aggregate functions include AVG, MIN, MAX, and SUM.