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

Answers were Sorted based on User's Feedback



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 ?    126 Yes 5 No

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

Answer / suneel

0

Is This Answer Correct ?    125 Yes 9 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

0

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

0

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

00

Is This Answer Correct ?    7 Yes 8 No

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

Answer / pothan

5

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

More SQL PLSQL Interview Questions

1. Which is an aggregate function? a. Union b. like c. max d. Rank

1 Answers   Fintellix,


define sql insert statement ? : Sql dba

0 Answers  


What is the difference between alter trigger and drop trigger statements?

0 Answers  


What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?

2 Answers  


How do you clear the screen in sql?

0 Answers  






Explain the difference between sql and mysql.

0 Answers  


What is difference between sql and mysql?

0 Answers  


how to use 'mysql' to run sql statements? : Sql dba

0 Answers  


I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 Answers  


What is the difference between rollback and rollback to statements?

0 Answers  


How to get list of all tables from a database?

0 Answers  


name 3 ways to get an accurate count of the number of records in a table? : Sql dba

0 Answers  


Categories