SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

SELECT ROUND(TRUNC(MOD(1600,10),-1),2)
FROM dual;

Question Posted / star dba

10 Answers
73815 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;..

Answer / suneel

Is This Answer Correct ?

124 Yes

9 No

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;..

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

114 Yes

5 No

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;..

Answer / dharmendra

0 only

Is This Answer Correct ?

39 Yes

3 No

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;..

Answer / subbu

Is This Answer Correct ?

16 Yes

0 No

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;..

Answer / sathish p

First mod(1600,10) output is 0...
So total output ZERO only..

Is This Answer Correct ?

10 Yes

2 No

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;..

Answer / shadrak

Is This Answer Correct ?

8 Yes

1 No

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;..

Answer / manish kumar

0.00

Is This Answer Correct ?

8 Yes

4 No

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;..

Answer / ankit agarwal

Is This Answer Correct ?

6 Yes

8 No

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;..

Answer / pothan

Is This Answer Correct ?

3 Yes

7 No

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;..

Answer / ankit agarwal

error

Is This Answer Correct ?

8 Yes

13 No

Post New Answer