<div>
SELECT Field1, SUBSTRING(MAX(CONVERT(CHAR<wbr />(19),Field<wbr />3)+Field2)<wbr />,19,128)<br />
&nbsp; FROM YourTable<br />
&nbsp;GROUP BY Field1<br />
<br />
The trick is to append Field2 on the end of the timestamp so that when you find the MAX of the combined field, you can get back just the Field2 part of it. &nbsp;This is easiest when both Field2 and Field3 are string data types but you can use the CONVERT function to deal with whatever combination you may have.<br />
<br />
Bill
</div>


SELECT Field1, SUBSTRING(MAX(CONVERT(CHAR(19),Field3)+Field2),19,128)
  FROM YourTable
 GROUP BY Field1

The trick is to append Field2 on the end of the timestamp so that when you find the MAX of the combined field, you can get back just the Field2 part of it.  This is easiest when both Field2 and Field3 are string data types but you can use the CONVERT function to deal with whatever combination you may have.

Bill

<div>
<div class="content wysiwyg-content">
Given: A Sybase SQL table arranged as &quot;Field1 | Field2 | Field3 ....&quot;<br />
<br />
Each Field1 will have one or more Field2's associated with it as shown below. &nbsp;Field3 is a timstamp.<br />
<br />
Field1 | Field2a | Field3<br />
Field1 | Field2b | Field3<br />
Field1 | Field2c | Field3<br />
<br />
Selecting a given Field1 would return three rows because of the three different Field2 values. &nbsp;I need to return exactly one row for each unique Field1. &nbsp;That row must be the one with the most recent timestamp.<br />
<br />
Thank you<br />
<br />
<br />

</div>
</div>


Given: A Sybase SQL table arranged as "Field1 | Field2 | Field3 ...."

Each Field1 will have one or more Field2's associated with it as shown below.  Field3 is a timstamp.

Field1 | Field2a | Field3
Field1 | Field2b | Field3
Field1 | Field2c | Field3

Selecting a given Field1 would return three rows because of the three different Field2 values.  I need to return exactly one row for each unique Field1.  That row must be the one with the most recent timestamp.

Thank you




Select only one matching row via SQL

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.