devide and summarize sql result (all)

Поиск
Список
Период
Сортировка
Искать
От
Janek Sendrowski
Тема
devide and summarize sql result (all)
Дата
Msg-id
trinity-0b9049c3-e16e-4678-86b2-d2a6aee7c54a-1376599895611@3capp-webde-bs20
Список
Дерево обсуждения
devide and summarize sql result (all) "Janek Sendrowski" <janek12@web.de>
Re: devide and summarize sql result (all) bricklen <bricklen@gmail.com>
Re: devide and summarize sql result (all) "Janek Sendrowski" <janek12@web.de>
Re: devide and summarize sql result (all) salah jubeh <s_jubeh@yahoo.com>
Re: devide and summarize sql result (all) Beena Emerson <memissemerson@gmail.com>
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 по дате отправления
От: Janek Sendrowski
Дата:
От: Adrian Klaver
Дата:
FAQ