SELECT ROUND(TRUNC(MOD(1600,10),-1),2)
FROM dual;
Answer Posted / girija shankar dash
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
How does a covering index work?
Explain the components of sql?
what is sql server agent? : Sql dba
Which type of cursor is used to execute the dml statement?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is the difference between delete and truncate commands?
How do you use collections in procedure to return the resultset?
What is a record in a database?
Explain spool.
How do I remove all records from a table?
Explain what is a field in a database and record in a database?
How do I tune a sql query?
What is duration in sql profiler trace?
State some properties of relational databases?
What is the difference between between and in condition operators?