Counting distinct names

Поиск
Список
Период
Сортировка
От G. Anthony Reina
Тема Counting distinct names
Дата
Msg-id 38FBBD02.4424CB34@nsi.edu
обсуждение исходный текст
Ответы Re: Counting distinct names  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
Re: Counting distinct names  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Let's say I have a table:

table1
=====

subject_name         text
subject_age            int4
test_trial                int4
test_score               int4


I'd like to find out how many times a unique 'subject_name' is in the
table. My SQL book says that I should be able to do this:

select COUNT(DISTINCT subject_name) from table1;

However, the psql program is giving me an "ERROR:  parser: parse error
at or near "distinct"".

Is there another way to do this (or a problem with my query)?

Thanks.
-Tony Reina

Using [PostgreSQL 6.5.1 on i686-pc-linux-gnu, compiled by gcc
egcs-2.91.66]




В списке pgsql-sql по дате отправления:

Предыдущее
От: Titus Brown
Дата:
Сообщение: Re: [GENERAL] Connecting website with SQL-database.....
Следующее
От: "Brett W. McCoy"
Дата:
Сообщение: Re: Counting distinct names