List:General Discussion« Previous MessageNext Message »
From:Helen M Hudson Date:July 13 2006 9:16am
Subject:quickie for a non-blonde!
View as plain text  
If I have a table
primary key id   |  code            | name
1                       |  ABC           | company 1 name
2                       |  ABC           | company 1 name
3                       |  ABC           | new company 1 name
4                       |  ABC           | new company 1 name
5                       |  DEF            | company 2 name
6                       |  DEF            | company 2 name
7                       |  DEF            | new company 2 name
8                       |  DEF            | new company 2 name

(the company is changing name every now and then and i need to extract their 
"latest" name)

how can i get back
4                       |  ABC           | new company 1 name
8                       |  DEF            | new company 2 name


Thread
summing valuesKathy Mazur Worden30 Jun
  • Re: summing valuesPeter Brawley30 Jun
    • RE: summing valuesKathy Mazur Worden30 Jun
  • quickie for a non-blonde!Helen M Hudson13 Jul
    • Re: quickie for a non-blonde!Mike Aubury13 Jul