Hi,
Say if you have a database which has some kind of duplicating entries.....
for example:
column 1 is skilllevel, column 2 is dateid, column 3 is passportid (person)...
table could be:
1,Aug31 2006,10013
2,Aug31 2006,10013
2,Sep 19 2006,10014
3,Sep 19 2006,10014
Of course, the higher the "skill level" the better..... so the mathematical expression is looking at column 3 which is the most important, and saying that he acheived his highest level of 2, therefore i need to delete the line where level 1 has been acheived....
So the final table should look like:
2,Aug31 2006,10013
3,Sep 19 2006,10014
as 10013 highest level achieved was 2
and for 100014 highest level achieved was 3.
I hope this makes sense.....
Appreciate some help if you could......
Regards
Jay
Say if you have a database which has some kind of duplicating entries.....
for example:
column 1 is skilllevel, column 2 is dateid, column 3 is passportid (person)...
table could be:
1,Aug31 2006,10013
2,Aug31 2006,10013
2,Sep 19 2006,10014
3,Sep 19 2006,10014
Of course, the higher the "skill level" the better..... so the mathematical expression is looking at column 3 which is the most important, and saying that he acheived his highest level of 2, therefore i need to delete the line where level 1 has been acheived....
So the final table should look like:
2,Aug31 2006,10013
3,Sep 19 2006,10014
as 10013 highest level achieved was 2
and for 100014 highest level achieved was 3.
I hope this makes sense.....
Appreciate some help if you could......
Regards
Jay