View Full Version : Help with Query - List of players with W$SD > X
Galandil
04-02-2011, 10:12 AM
I'm somewhat a n00b with queries, so I'd like to know if there's a way, via pgAdmin, to write one query which gives me the list of all players name that won at showdown more or equal than a certain amount.
For example, the list of players who won globally more than 55% of showdowns (w$sd>55%).
Thank you in advance. :)
Cabbage
04-19-2011, 03:07 PM
Do you specifically need it in pgAdmin ?
You could get it from the 'Players' tab default report if not.
Galandil
04-19-2011, 05:22 PM
Do you specifically need it in pgAdmin ?
You could get it from the 'Players' tab default report if not.
No, I don't it need it in pgAdmin.
But AFAIK there's no way in HM to get a report showing the W$SD for ALL players in a single listing of a db.
For example, I have only 4 players, named A-D, so the report should be something like this:
A - W$SD 47,5%
B - W$SD 51%
C - W$SD 54,7%
D - W$SD 49,3%
Without, ofc, selecting them one by one. And furthermore, I'd like to filter out all players with a stat > of a set value (for example, "give me all players having a W$SD higher than 55%").
justin.nc
04-25-2011, 04:05 AM
I think you should be more specific, it certainly is in the admin
_________________
Muốn có nội thất văn pḥng (http://www.noithatvanphong.net.vn) đẹp bạn phải có dịch vụ thiết kế nội thất văn pḥng (http://www.noithatvanphong.net.vn) tốt, bên cạnh việc thiết kế nội thất (http://www.noithatvanphong.net.vn/thiet-ke-noi-that.html) bạn phải tạo ra vách ngăn văn pḥng (http://www.noithatvanphong.net.vn/vach-ngan-van-phong.html) đẹp cho không gian văn pḥng của bạn.
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.