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 ? | 116 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 the Default Libraries for Oracle Report 6i
How to get list of all tables from a database?
What is number function in sql?
What is thread join () in threading?
How do I view a sql database?
how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900
Give the structure of the procedure ?
What does seeding a database mean?
What is offset in sql query?
how to drop an existing table in mysql? : Sql dba
how to use myisamchk to check or repair myisam tables? : Sql dba
Explain about various levels of constraint.