Skip to Content
0
Former Member
Oct 20, 2006 at 09:08 AM

SELECT biggest row wich considerations to MAX(date)

21 Views

Hi,

I want to select the entire row which has the biggest name grouped by name and last.

But the thing is I want to select the entire row because i want to put the entire row into a structure and not just a few fields. In psedocode I want to do:

SELECT * WITH REGARDS TO MAX(Date)

FROM myTable

INTO myTable_Structure

GROUP BY name last.

How do I achieve this?

Name Last Date

Emil Larsson 200609

Emil Larsson 200611

Emil Larsson 200610