ANS: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) as "result" FROM d

SELECT ROUND(TRUNC(MOD(1600,10),-1),2)
FROM dual;

Question Posted / girija shankar dash

10 Answers
78420 Views
I also Faced
E-Mail Answers

ANS:
SELECT ROUND(TRUNC(MOD(1600,10),-1),2) as "result"
FROM dual;

Result
------
0

Explanation:
-----------
MOD(1600,10)---> 0
TRUNC(0,-1)----> 0
ROUND(0,2)-----> 0

Is This Answer Correct ?

126 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we write dml inside a function in sql server?

678

How many clustered indexes can you have?

730

What is sql resultset?

729

What is sqlservr exe?

699

What is the size of partition table?

742

Is sql a dbms?

732

What are the different tcl commands in sql?

815

Enlist the data types that can be used in pl/sql?

749

what is the difference between clustered and non clustered index in sql? : Sql dba

737

What is error ora-12154: tns:could not resolve the connect identifier specified?

826

What is sqlexception in java?

732

What are three advantages to using sql?

732

Which is faster count (*) or count 1?

757

what is dbms? : Sql dba

738

What is trigger explain it?

740