Home » SQL & PL/SQL » SQL & PL/SQL » AVG Function
AVG Function [message #23104] Mon, 18 November 2002 11:55 Go to next message
Rizwan Qazi
Messages: 135
Registered: August 2002
Senior Member
I am using the AVG function in a SQL query and am ending up with as many decimal places as the remaining space in the field. How can I control this to display the value with 2 or 3 decimal places

Rizwan

Report message to a moderator

Re: AVG Function [message #23105 is a reply to message #23104] Mon, 18 November 2002 12:17 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
 
round(avg(column), 2)

Report message to a moderator

Previous Topic: View functions and procedures
Next Topic: index rebuild -- snap shot too old error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 06:15:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.