Date Selection

drshimbo · #1 (**permalink**) 04-03-06, 17:27

I have 20 rows in a database made up of 5 different names, so I have 4 rows with the same name the only difference being that they have a different date and address. How do I create a query to select the name and address based on the latest date for each of the different names.

andrewst · #2 (**permalink**) 04-04-06, 07:05

Code:

select name, address
from   mytable t1
where  t1.datecol = (select max(t2.datecol)
                     from   mytable t2 
                     where  t2.name = t1.name
                    );

drshimbo · #3 (**permalink**) 05-12-06, 16:30

Many thanks for the reply, tried it and it worked perfectly to give me the information I required.

Internet Services

Web Development

Digital Marketing

Consumer Tech