SELECT ROUND(TRUNC(MOD(1600,10),-1),2)
FROM dual;
Answers were Sorted based on User's Feedback
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 ? | 117 Yes | 5 No |
Answer / sathish p
First mod(1600,10) output is 0...
So total output ZERO only..
Is This Answer Correct ? | 10 Yes | 2 No |
What is a full join sql?
How do you remove duplicate records from a table?
Is sql a dbms?
What is the current version of sql?
explain the difference between myisam static and myisam dynamic. : Sql dba
What do you mean by field in sql?
what are the different type of sql's statements ? : Sql dba
What is the use of desc in sql?
Can we join more than 2 tables in sql?
List out the acid properties and explain?
What is RAC in oracle?
Explain the order of sql statement execution?