Find the output of the following SQL Query : SELECT | KnowledgeBoat

Informatics Practices

Find the output of the following SQL Query :

SELECT ROUND(7658.345, 2);

SQL Queries

6 Likes

Answer

+--------------------+
| ROUND(7658.345, 2) |
+--------------------+
|            7658.35 |
+--------------------+

Working

In the query, the ROUND function is used to round a number to 2 decimal places, resulting in 7658.35.

Answered By

2 Likes

Related Questions

Write a command to display the current time.
View Answer Bookmark Now

Consider two fields Bdate, which stores the birth date and Jdate, which stores the joining date of an employee. Write commands to find out and display the approximate age of an employee as on today.
View Answer Bookmark Now
Find the output of the following SQL Query :
SELECT MOD(ROUND (13.9, 0), 3);
View Answer Bookmark Now
Write the SQL functions which will perform the following operations :
(i) To display the name of the month of the current date.
(ii) To remove spaces from the beginning and end of a string, "Panorama".
(iii) To display the name of the day e.g., Friday or Sunday from your date of birth, dob.
(iv) To display the starting position of your first name(fname) from your whole name (name).
(v) To compute the remainder of division between two numbers, n1 and n2.
View Answer Bookmark Now