Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

25.67,-1
Trunc = 20
Round= 30

HOW????

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


Please Help Members By Posting Answers For Below Questions

Why we use joins in sql?

1036


How many types of sql are there?

1047


how to analyze tables with 'mysqlcheck'? : Sql dba

1062


What are actual parameters and formal parameters?

1178


What is serial sql?

1043


How many sql statements are used? Define them.

1081


What is sqlite used for?

1048


what is the difference between where clause and having clause? : Sql dba

1046


How do I make sql search faster?

1044


Is primary key an index?

1036


What is before and after trigger?

1010


How to return multiple rows from the stored procedure?

1016


Can we connect to postgresql using sql developer?

1048


Does mysql support pl sql?

1233


What is mdb stand for?

1063