| From: | "Janek Sendrowski" <janek12(at)web(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | devide and summarize sql result (all) |
| Date: | 2013-08-15 20:51:35 |
| Message-ID: | trinity-0b9049c3-e16e-4678-86b2-d2a6aee7c54a-1376599895611@3capp-webde-bs20 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>Hi,<br/>
<br/>
My sql query results sth. like this:<br/>
<br/>
user percentage<br/>
franz 78%<br/>
smith 98%<br/>
franz 81%<br/>
jason 79%</div>
<div>smith 89%</div>
<div>smith 85%</div>
<div>smith 99%</div>
<div> </div>
<div>Now I'd like to summarize the percentages oder every user like this.</div>
<div>smith</div>
<div>2 matches 95-100%</div>
<div>2 matches 85-95%</div>
<div>0 mathes 75-85%</div>
<div> </div>
<div>franz</div>
<div>0 mathes 95-100%</div>
<div>...</div>
<div> </div>
<div>Hope there is someone who can help me</div>
<div> </div>
<div>Janek Sendrowksi</div></div></body></html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 746 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2013-08-15 21:20:11 | Re: Strange result with "SELECT ... ORDER BY random() LIMIT 1" and JOINs |
| Previous Message | Janek Sendrowski | 2013-08-15 20:46:54 | devide and summarize sql result |