Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formatting 1 decimal point output from AVG()

Status
Not open for further replies.
Shrum

Shrum

Programmer
May 17, 2002
122
US
I'm calculating the average on a field but the values I get back have too many decimals: '132.54363580'

How can I format the output of AVG() to be, say, 1 decimal point: '132.5'

TIA

=============================
Sean Shrum
Shrum Consulting
 
Status
Not open for further replies.

Similar threads

penguinspeaks
  • Locked
  • Question
Update column based on input from another column 3
Replies
6
Views
409
penguinspeaks
penguinspeaks
wilsjay22
  • Locked
  • Question
Freeing up disk space from information_schema
Replies
1
Views
320
jg2828
jg2828
PeDa
  • Locked
  • Question
Opening MySQL table from Microsoft Access
Replies
1
Views
189
PeDa
PeDa
AbidingDude
  • Locked
  • Question
Loading From A CSV File
Replies
2
Views
180
AbidingDude
AbidingDude
martinkaeser
  • Locked
  • Question
MySQL Query for incrementing field from duplicates in database
Replies
4
Views
175
martinkaeser
martinkaeser

Part and Inventory Search

Sponsor

Back
Top