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 ? | 126 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 |
1. Which is an aggregate function? a. Union b. like c. max d. Rank
define sql insert statement ? : Sql dba
What is the difference between alter trigger and drop trigger statements?
What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?
How do you clear the screen in sql?
Explain the difference between sql and mysql.
What is difference between sql and mysql?
how to use 'mysql' to run sql statements? : Sql dba
I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?
What is the difference between rollback and rollback to statements?
How to get list of all tables from a database?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba