Informatics Practices
What will be returned by the given query?
select round(23456.1234, -2) ;
- 23456.00
- 23400
- 23500
- 23456.1200
SQL Queries
3 Likes
Answer
23500
Reason — The query SELECT ROUND(23456.1234, -2); will return 23500. This is because the ROUND() function in SQL rounds the number 23456.1234 to the nearest hundredth position specified by -2, resulting in 23500.
Answered By
3 Likes
Related Questions
Online …………… is a theft of personal information in order to commit a fraud.
Identify the Single Row function of MySQL among the following:
- Trim ()
- Max ()
- Avg()
- Count()
Which one of the following functions is used to find the smallest value from the given data in MySQL?
- MIN()
- MINIMUM()
- SMALL()
- SMALLEST()
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