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
when MSQL8.0 is in market
How many sql core licenses do I need?
What are primary key and foreign key and how they work?
What is a sql trace file?
Describe sql comments?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
What is the main difference between sql and pl/sql?
Why use truncate instead of delete?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
Can we use update in sql function?
Why we use joins in sql?
Does mysql support pl sql?
What is blind sql injection?
What is sql in oracle?
what are integrity rules?