linux=# select nick, karma from users order by karma limit 10;
nick | karma
-----------------+--------
JB | -65584
megabaks | -135
uju | -92
filosof | -49
Lighting | -35
darkshvein | -29
Donnie_Darko | -28
different_thing | -13
babusha | -12
gadfly | -12
(10 rows)
linux=# select nick, karma from users order by karma desc limit 10;
nick | karma
--------------+-------
KRoN73 | 30
Dimez | 29
Macil | 27
svu | 27
Sylvia | 26
mironov_ivan | 24
Sun-ch | 21
hibou | 21
maxcom | 20
mono | 18
(10 rows)
PS: код тут https://github.com/maxcom/lorsource/commits/karma
.png)
