Page 1 of 1

sql query to may numbers

PostPosted: Wed Apr 02, 2008 4:27 pm
by kukimus
hi


if i have this sql query : avg(fbet=1, flop_bet/pre_flop_pot*2,0) as joojoojojojjo

and then it returns 2.33123536012367-eo2

so my question is are there a way program in the query that it will only show the foure first digits ? like this 55.55 ?


regards
k.

Re: sql query to may numbers

PostPosted: Wed Apr 02, 2008 5:02 pm
by APerfect10
ROUND( number, decimal precision)

ie) ROUND(4, 2) would return 4.00

Best regards,

Derek