Informatics Practices
Which one of the following functions is used to find the smallest value from the given data in MySQL?
- MIN()
- MINIMUM()
- SMALL()
- SMALLEST()
SQL Queries
2 Likes
Answer
MIN()
Reason — The MIN() is an aggregate function in MySQL that returns the minimum value from a set of values.
Answered By
1 Like
Related Questions
Identify the Single Row function of MySQL among the following:
- Trim ()
- Max ()
- Avg()
- Count()
What will be returned by the given query?
select round(23456.1234, -2) ;- 23456.00
- 23400
- 23500
- 23456.1200
Choose the correct statement to print the label in the line chart.
- pl.xlabel("some values")
- pl.xlable("some values")
- pl.plotlabel("some values")
- None of these
Which clause is used in query to place the condition on groups in MySQL?
- WHERE
- HAVING
- GROUP BY
- Both (i) & (ii)