counting query

Поиск
Список
Период
Сортировка
Искать
От
garry saddington
Тема
counting query
Дата
Msg-id
1169989544.29309.76.camel@localhost
Список
Дерево обсуждения
Re: counting query "Joris Dobbelsteen" <Joris@familiedobbelsteen.nl>
Re: counting query Douglas McNaught <doug@mcnaught.org>
I have a table definition such as:

CREATE TABLE attendance
(
  attendanceid serial primary key,
  entered date DEFAULT current_date NOT NULL,
  absent boolean,
  authorization text default 'N',
  timeperiod char(2) check(timeperiod in('AM','PM')),
  days varchar(10),
  studentid int,
  unique(entered,timeperiod,studentid)
)

Which is used to record school attendance data. I am now trying to write
a query to identify trends in absences by counting the days column and
returning any student that has repeated absences on certain days. I am
struggling to return anything that does not need further manipulation in
Python before being useful.
Does anyone have any ideas?

В списке pgsql-general по дате отправления
От: Dave Page
Дата:
От: Shane Ambler
Дата:
FAQ