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

Pick out the biggest element from a table with SELECT

16 Views

Hi,

I have a table with 3 columns. The table looks like the example below. There can be same persons with different dates.

I want to withoud using for loops, just using select statement pick out Emil Larsson with the biggest date, that is the most recent date up to today. How do you achieve this with select statements?

Name LastName Date

John Larsson 20061001

Emil Larsson 20060927

John Larsson 20061006

Emil Larsson 20061018

regards

Baran