Query question

Поиск
Список
Период
Сортировка
От Stanton Schmidt
Тема Query question
Дата
Msg-id 415803152.48510563.1520535505737.JavaMail.zimbra@rglholdings.com
обсуждение исходный текст
Ответы Re: Query question  (Martin Stöcker <martin.stoecker@stb-datenservice.de>)
Re: Query question  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-sql
Hi, 
I am new to the list so feel free to let me know if I am out of line.

My question is:
I have a table that has log events for pieces of equipment.  For each piece of equipment this table may contain 1 or more (hundreds potentially).
I need to write a query that will return only the last 5 log events for each (and every) piece of equipment.

log_table (
equipment_id character(30),
log_date date,
log_time time,
event_desc text
)

Thanks for your help.

stanton schmidt
Database Administrator
direct. 920.471.4495  cell 920.660.1828

RGL
GO AHEAD. ASK WHAT IF.
www.RGLlogistics.co m

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

Предыдущее
От: Gary M
Дата:
Сообщение: Re: How to best migrate this nested join ?
Следующее
От: Martin Stöcker
Дата:
Сообщение: Re: Query question