PDA

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.