sql query to may numbers

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

sql query to may numbers

Postby kukimus » Wed Apr 02, 2008 4:27 pm

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.
kukimus
 
Posts: 18
Joined: Mon Mar 31, 2008 3:20 pm

Re: sql query to may numbers

Postby APerfect10 » Wed Apr 02, 2008 5:02 pm

ROUND( number, decimal precision)

ie) ROUND(4, 2) would return 4.00

Best regards,

Derek
APerfect10
Site Admin
 
Posts: 4489
Joined: Sat Dec 08, 2007 6:03 pm


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests