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

How does a covering index work?

960

Explain the components of sql?

1061

what is sql server agent? : Sql dba

1103

Which type of cursor is used to execute the dml statement?

957

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

1829

What is the difference between delete and truncate commands?

1039

How do you use collections in procedure to return the resultset?

2238

What is a record in a database?

1062

Explain spool.

1179

How do I remove all records from a table?

1074

Explain what is a field in a database and record in a database?

1097

How do I tune a sql query?

974

What is duration in sql profiler trace?

1079

State some properties of relational databases?

1056

What is the difference between between and in condition operators?

1005