Answer Posted / gaurav
The TRUNC (n1, n2) function returns n1 truncated to n2 decimal places. If n2 is omitted, then n1 is truncated to 0 places. n2 can be negative to truncate (make zero) n2 digits left of the decimal point.
if you do it -2. answer will be zero in this case.
similar thing goes for round.It will become zero.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What do you mean by query optimization?
What is difference between cursor and trigger?
Explain normalization and what are the advantages of it?
What is orm in sql?
What is file based approach?
what are rollup and cube in t-sql? : Transact sql
tell us something about heap tables. : Sql dba
Explain the insert into statements in sql?
What is a pdo connection?
When sql appeared?
explain about mysql and its features. : Sql dba
What is the need of a partition key?
How do you update a value in sql?
What is t sql used for?
What programs use sql?