Postgres Pro
Downloads
Home   >   mailing lists

devide and summarize sql result (all) - Mailing list pgsql-general

From Janek Sendrowski
Subject devide and summarize sql result (all)
Date
Msg-id trinity-0b9049c3-e16e-4678-86b2-d2a6aee7c54a-1376599895611@3capp-webde-bs20
Whole thread Raw
Responses Re: devide and summarize sql result (all)  (bricklen <bricklen@gmail.com>)
Re: devide and summarize sql result (all)  (Beena Emerson <memissemerson@gmail.com>)
List pgsql-general
Tree view 
Hi,
 
My sql query results sth. like this:
 
user percentage
franz 78%
smith 98%
franz 81%
jason 79%

smith 89%

smith 85%

smith 99%

 

Now I'd like to summarize the percentages oder every user like this.

smith

2 matches 95-100%

2 matches 85-95%

0 mathes 75-85%

 

franz

0 mathes 95-100%

...

 

Hope there is someone who can help me

 

Janek Sendrowksi

pgsql-general by date:

Previous
From: "Janek Sendrowski"
Date:
Subject: devide and summarize sql result
Next
From: Adrian Klaver
Date:
Subject: Re: Strange result with "SELECT ... ORDER BY random() LIMIT 1" and JOINs