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
80229 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 ?

127 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you declare a user-defined exception?

958

What is the difference between syntax error and runtime error?

1064

Is inner join same as self join?

1059

How to disable a trigger name update_salary?

1192

What is the difference between count 1 and count (*) in a sql query?

903

How to move files from one directory to another in pl sql?

1127

What is plpgsql language?

971

how to install mysql? : Sql dba

1041

What program will open a mdb file?

909

How do I view a view in sql?

886

Which is faster subquery or join?

1141

What is cursor in pl sql with examples?

950

What does joining a thread mean?

972

What are the differences between implicit and explicit cursors?

999

What is the difference between function and procedure in pl/sql?

1013