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

What is mutating trigger?

1073

What is query execution plan in sql?

1249

Can we call procedure in select statement?

1113

What are the different types of dbmss?

1058

what are the features and advantages of object-oriented programming? : Sql dba

1075

Can a commit statement be executed as part of a trigger?

1105

what is 'trigger' in sql? : Sql dba

1147

How can I change database name in sql?

1158

What is the difference between microsoft access and sql server?

1108

Can we connect to postgresql using sql developer?

1048

explain the difference between delete , truncate and drop commands? : Sql dba

1147

What is ttitle and btitle?

1116

What are the different ddl commands in sql?

1251

Is pl sql and postgresql same?

1183

What are the different types of joins in sql?

1914