select trunc(25.67,-1),round(30) from dual; TRUNC(25.67,-1) ROUND(30)

25.67,-1
Trunc = 20
Round= 30

HOW????

Question Posted / chandu

Answer Posted / chandu

select trunc(25.67,-1),round(30) from dual;

TRUNC(25.67,-1) ROUND(30)
--------------- ----------
20 30

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

how to write date and time literals? : Sql dba

962

Why schema is used in sql?

1050

how would you get the current date in mysql? : Sql dba

967

what are the disadvantages of mysql? : Sql dba

1149

Can you sum a count in sql?

1013

What are the commands used in sql?

1079

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

953

What are different joins used in sql?

1057

Is pl sql useful?

995

What is the difference between a database and a relational database?

1103

How do I order columns in sql?

1008

What are tables and fields in the database?

1112

give the syntax of grant and revoke commands? : Sql dba

1153

How to assign sql query results to pl sql variables?

1081

Does user triggers have entry for trigger with compilation errors?

1035