Question

61. Which functions can be used with any datatype? Please select all the correct
answers.
A. SUM
B. MIN
C. MAX
D. AVG​

Answer 1

Answer:

The functions MAX, MIN and AVG can be used as GROUP BY functions. ... Answer: A, B, C, D. All the listed group functions can be used in a query provided no ... What are the appropriate data types accepted by GROUP BY functions

Explanation:

Answer 2

Answer: MIN and MAX

Explanation: MIN and MAX are SQL aggregation functions that return the lowest and highest values ​​in a particular column.

They are similar to COUNT in that they can be used on non-numeric columns. Depending on the column type, MIN will return the lowest number, the earliest date, or a non-numeric value alphabetically as close to "A" as possible. As you might suspect, MAX does the opposite—it returns the highest number, the latest date, or the non-numeric value alphabetically closest to "Z".

MAX and MIN operate on columns that contain character, graphic, numeric, date/time, and binary data (except for binary large object, or BLOB, data).

#SPJ3