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
by 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
by 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]
Users browsing this forum: No registered users and 0 guests