Interested to Buy Any Domain ? << Click Here >> for more details...
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 does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
what are the advantages a stored procedure? : Sql dba
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
Can we insert data in view?
What is rownum in sql?
What is anonymous block in sql?
What is a database? Explain
Why select is used in sql?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
What is an invalid partition table?
how to dump a table to a file with 'mysqldump'? : Sql dba
What is view? Can we update view
What does fetching a cursor do?
what is innodb? : Sql dba
What are different types of triggers?
