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
80260 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

What is a dirty read sql?

1036

what is the difference between truncate and drop statements? : Sql dba

1036

How do I upgrade sql?

949

Can you have more than one key in a database?

893

what is 'mysqlcheck'? : Sql dba

960

What is using in sql?

1019

How does cross join work?

877

What is normalisation and its types?

957

Explain what is a database?

1039

What is data abstraction in sql?

969

How do you change a value in sql?

968

What are sql functions? Describe the different types of sql functions?

1060

What is a nested table in word?

911

What is right join sql?

922

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

944