Re: DONT_CARE Aggregate
| От | Richard Broersma |
|---|---|
| Тема | Re: DONT_CARE Aggregate |
| Дата | |
| Msg-id | CABvLTWES-rWJtUrOE+Y0k-3MSG6S59JyRyE5osrsHBPUkOB7ZQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: DONT_CARE Aggregate (Robert James <srobertjames@gmail.com>) |
| Ответы |
Re: DONT_CARE Aggregate
|
| Список | pgsql-general |
On Thu, Dec 20, 2012 at 5:45 AM, Robert James <srobertjames@gmail.com> wrote:
Here is an example:
buildinghac=>
SELECT itemnbr, buildingnbr
FROM Actionitems
ORDER BY buildingnbr
LIMIT 10;
itemnbr | buildingnbr
---------+-------------
1181 | B-0106
363 | B-0106
185 | B-0106
483 | B-0106
67 | B-0106
125 | B-0106
303 | B-0106
245 | B-0106
68 | B-0107
304 | B-0107
(10 rows)
buildinghac=>
SELECT DISTINCT ON ( buildingnbr )
itemnbr, buildingnbr
FROM Actionitems
ORDER BY buildingnbr
LIMIT 10;
itemnbr | buildingnbr
---------+-------------
245 | B-0106
364 | B-0107
1170 | B-0111
361 | B-0112
128 | B-0116
1013 | B-0117
129 | B-0118
368 | B-0300
1141 | B-0307
74 | B-0423
(10 rows)
--
Regards,
Richard Broersma Jr.
Sergey - That's an interesting option, but I'm not sure how to use it
as an aggregate. Could you give an example?
Here is an example:
buildinghac=>
SELECT itemnbr, buildingnbr
FROM Actionitems
ORDER BY buildingnbr
LIMIT 10;
itemnbr | buildingnbr
---------+-------------
1181 | B-0106
363 | B-0106
185 | B-0106
483 | B-0106
67 | B-0106
125 | B-0106
303 | B-0106
245 | B-0106
68 | B-0107
304 | B-0107
(10 rows)
buildinghac=>
SELECT DISTINCT ON ( buildingnbr )
itemnbr, buildingnbr
FROM Actionitems
ORDER BY buildingnbr
LIMIT 10;
itemnbr | buildingnbr
---------+-------------
245 | B-0106
364 | B-0107
1170 | B-0111
361 | B-0112
128 | B-0116
1013 | B-0117
129 | B-0118
368 | B-0300
1141 | B-0307
74 | B-0423
(10 rows)
--
Regards,
Richard Broersma Jr.
В списке pgsql-general по дате отправления: