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

What are analytic functions in sql?

972


What is query execution plan in sql?

1130


What is sql partition?

1038


What is substitution variable?

1003


Which join is like an inner join?

954


Who developed sql?

962


Can we use pl sql in sql server?

1013


Why trigger is used in sql?

916


what is csv? : Sql dba

946


How many sql core licenses do I need?

884


What are dml commands?

943


What is the benefit of foreign key?

962


What are pl sql data types?

957


What are the different types of triggers?

1056


What is nvl?

1018