Search Postgresql Archives

grouping excluding some text results

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

ho can I select some one restult for type, excluding the rest?
I have something like, as result of a join:

|   ID   |   score    |          description           |
-----------------------------------------------------------------
MG01      56           "textual description1..."
MG02      47           "another text ..."
MG02      55           "textual description, text...."        <----
note this
MG02      55           "textual description, text...."        <----
note this
MG01      35           "this is a different text...."
MG02      61           "random chars..."
(...)


I know that is possible selecting by grouping if I use an aggregate
function:
> select ID,max(score) by table group by ID
but I want the description too, only one description, and I have a very
large dataset, I cannot cycle with more subselections, this require too
much time; also I want to exclude duplicates: only one ID.

What can I do?



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux