Call volume query

Поиск
Список
Период
Сортировка
От Mike Diehl
Тема Call volume query
Дата
Msg-id 1233269836.13476.10.camel@ubuntu
обсуждение исходный текст
Список pgsql-general
Hi all.

I've encountered an SQL problem that I think is beyond my skills...

I've got a table full of records relating to events (phone calls, in
this case) and I need to find the largest number of events (calls)
occurring at the same time.

The table had a start timestamp and a duration field which contains the
length of the call in seconds.

I need to find out how many concurrent calls I supported, at peek
volume.

Can this be done in SQL?  Or do I need to write a perl script?

Thank you,
Mike.


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

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: How relate pg_class to pg_constraint
Следующее
От: Greg Smith
Дата:
Сообщение: Re: Pet Peeves?