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
Why we use joins in sql?
How many types of sql are there?
how to analyze tables with 'mysqlcheck'? : Sql dba
What are actual parameters and formal parameters?
What is serial sql?
How many sql statements are used? Define them.
What is sqlite used for?
what is the difference between where clause and having clause? : Sql dba
How do I make sql search faster?
Is primary key an index?
What is before and after trigger?
How to return multiple rows from the stored procedure?
Can we connect to postgresql using sql developer?
Does mysql support pl sql?
What is mdb stand for?