Query question
| От | Stanton Schmidt |
|---|---|
| Тема | Query question |
| Дата | |
| Msg-id | 415803152.48510563.1520535505737.JavaMail.zimbra@rglholdings.com обсуждение исходный текст |
| Ответы |
Re: Query question
Re: Query question |
| Список | 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
RGL
direct. 920.471.4495 cell 920.660.1828
RGL
GO AHEAD. ASK WHAT IF.
www.RGLlogistics.co m
www.RGLlogistics.co m
В списке pgsql-sql по дате отправления: