What is the output of the following query?
SELECT TRUNC(1234.5678,­2) FROM DUAL;

 Posted by Abhisek on 1/21/2010 | Category: Sql Server Interview questions | Views: 4705
Answer:

1200


Asked In: Interviews | Alert Moderator 

Comments or Responses

Posted by: Gauravsharma on: 12/30/2010 | Points: 10
SELECT TRUNC(1234.5678,­2) FROM DUAL

for the above query the ans is 1234.56 not 1200

for this ans, the question should be SELECT TRUNC(1234.5678,­-2) FROM DUAL


Login to post response