Sarthaks APP
0 votes
in Information Technology by (47.6k points)
closed by

Consider the decimal number x with value 8459.2654. Write commands in SQL to: 

i. round it off to a whole number 

ii. round it to 2 places before the decimal.

1 Answer

+1 vote
by (46.6k points)
selected by
Best answer

i. select round(8459.2654); round(8459.2654,-2);

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.