What will be returned by the given query? select round(23456.1234, -2) ; 1. 23456.00 2. 23400 3. 23500 4. 23456.1200

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

Informatics Practices

What will be returned by the given query?

SQL Queries

Answer

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

Informatics Practices

What will be returned by the given query?

SQL Queries

Answer

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

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