Subject: Re: Query question
To: pgsql-sql@lists.postgresql.org
References: <415803152.48510563.1520535505737.JavaMail.zimbra@rglholdings.com>
From: =?UTF-8?Q?Martin_St=c3=b6cker?= <martin.stoecker@stb-datenservice.de>
Message-ID: <e22d829f-77f2-86c9-e89d-6885bc1fc56d@stb-datenservice.de>
Date: Thu, 8 Mar 2018 20:07:30 +0100
User-Agent: Mozilla/5.0 (Windows NT 6.0; rv:52.0) Gecko/20100101
 Thunderbird/52.6.0
MIME-Version: 1.0
In-Reply-To: 
 <415803152.48510563.1520535505737.JavaMail.zimbra@rglholdings.com>
Content-Type: multipart/alternative;
 boundary="------------38FB428AF38474977D3563C2"
Content-Language: de
Precedence: bulk

This is a multi-part message in MIME format.
--------------38FB428AF38474977D3563C2
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit

My first idea is to select all equipments and lateral join them to the 5 
most recent events

Regards Martin

Am 08.03.2018 um 19:58 schrieb Stanton Schmidt:
> 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. <callto:920.884.1281>471.4495  cell 920.660.1828
>
> RGL
> GO AHEAD.ASKWHAT IF.
> www.RGLlogistics.co m <http://www.rgllogistics.com/>


--------------38FB428AF38474977D3563C2
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    My first idea is to select all equipments and lateral join them to
    the 5 most recent events<br>
    <br>
    Regards Martin<br>
    <br>
    <div class="moz-cite-prefix">Am 08.03.2018 um 19:58 schrieb Stanton
      Schmidt:<br>
    </div>
    <blockquote type="cite"
cite="mid:415803152.48510563.1520535505737.JavaMail.zimbra@rglholdings.com">
      <div style="font-family: arial, helvetica, sans-serif; font-size:
        12pt; color: #000000">
        <div>Hi, </div>
        <div>I am new to the list so feel free to let me know if I am
          out of line.</div>
        <div><br data-mce-bogus="1">
        </div>
        <div>My question is:</div>
        <div>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).</div>
        <div>I need to write a query that will return only the last 5
          log events for each (and every) piece of equipment.</div>
        <div><br data-mce-bogus="1">
        </div>
        <div>log_table (</div>
        <div>equipment_id character(30),</div>
        <div>log_date date,</div>
        <div>log_time time,</div>
        <div>event_desc text</div>
        <div>)</div>
        <div><br data-mce-bogus="1">
        </div>
        <div>Thanks for your help.</div>
        <div><br data-mce-bogus="1">
        </div>
        <div data-marker="__SIG_PRE__">
          <div style="font-style: normal; font-variant-ligatures:
            normal; font-variant-caps: normal; letter-spacing: normal;
            orphans: 2; text-align: start; text-indent: 0px;
            text-transform: none; white-space: normal; widows: 2;
            word-spacing: 0px; -webkit-text-stroke-width: 0px;"><span
              style="color: #66cc66; font-family: arial; font-size:
              x-large;"><span style="background-color: rgb(253, 253,
                253);"><b>stanton schmidt</b></span></span></div>
          <div style="color: rgb(0, 0, 0); font-family: arial,
            helvetica, sans-serif; font-size: 16px; font-style: normal;
            font-variant-ligatures: normal; font-variant-caps: normal;
            letter-spacing: normal; orphans: 2; text-align: start;
            text-indent: 0px; text-transform: none; white-space: normal;
            widows: 2; word-spacing: 0px; -webkit-text-stroke-width:
            0px; background-color: rgb(253, 253, 253);"><b>Database
              Administrator</b><br>
            <div style="font-weight: normal; font-family: arial;"><span
                style="font-size: small;">direct. <span class="Object"
                  id="OBJ_PREFIX_DWT1098_com_zimbra_phone" style="color:
                  #336699; text-decoration: none; cursor: pointer;"><a
                    href="callto:920.884.1281" target="_blank"
                    style="color: #336699; text-decoration: none;
                    cursor: pointer;" moz-do-not-send="true">920.</a>471.4495
                   cell 920.660.1828</span></span></div>
            <div style="font-weight: normal; font-family: arial;
              font-size: 12pt;"><span style="font-weight: bold;"><br>
                RGL<br>
              </span><span style="font-size: xx-small;"></span></div>
            <div style="font-weight: normal; font-family: arial;"><span
                style="font-size: xx-small;"><span style="font-size:
                  small;">GO AHEAD.<span style="font-weight: bold;"> </span>ASK<span
                    style="font-weight: bold;"> </span></span><span
                  style="color: #66cc66;"><span style="font-size:
                    small;"><span style="font-weight: bold;">WHAT IF.</span></span><br>
                  <span style="font-weight: bold; font-size: small;"><span
                      class="Object"
                      id="OBJ_PREFIX_DWT1099_com_zimbra_url"
                      style="color: #336699; text-decoration: none;
                      cursor: pointer;"><span class="Object"
                        id="OBJ_PREFIX_DWT558_com_zimbra_url"
                        style="color: #005a95; text-decoration: none;
                        cursor: pointer;"><a target="_blank"
                          href="http://www.rgllogistics.com/"
                          style="color: #336699; text-decoration: none;
                          cursor: pointer;" moz-do-not-send="true">www.RGLlogistics.co
                          m</a></span></span></span></span></span><br>
            </div>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
  </body>
</html>

--------------38FB428AF38474977D3563C2--