Hi All,
I have a file with IDs like this:
1.2, 1.2 1.3, 2.1, 2.2, 2.3, 2.4, 3.1, 4.1, 5.1, 5.2, ...
Each ID is N.X where X is a numeric secondary ID number from 1 going upwards and N is the primary ID number which may or may not be numeric. Different primary IDs have a different number of secondary IDs.
For a certain report, I want to select only the records with the highest numerical value of X for each of N. For the above example, I want to end up with 1.3, 2.4, 3.1, 4.1, 5.2, Can a SELECT statement(s) be composed without having to write a program? If not what would be the best approach.
Thanks for any help.
Marco
BT Yahoo! Broadband - Free modem offer, sign up online today and save �80
-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
