Hi All,
Been a while since I posted
Things have been going well...but am now stuck
Here is what I need to do...
I have a table with circa 400k telephone numbers in it. These numbers have an analysis code next to them which is the first 6 digits of the number, thus enabling me to group numbers by range and type/tariff. There are 62 different analysis codes.
What I need to do is design a select query that gives me 2 records for each analysis code....how do I get my query to limit the selection of records for analysis codes?
Any help is as always greatly appreciated
Cheers,
Tommy B
Been a while since I posted


Here is what I need to do...
I have a table with circa 400k telephone numbers in it. These numbers have an analysis code next to them which is the first 6 digits of the number, thus enabling me to group numbers by range and type/tariff. There are 62 different analysis codes.
What I need to do is design a select query that gives me 2 records for each analysis code....how do I get my query to limit the selection of records for analysis codes?
Any help is as always greatly appreciated

Cheers,
Tommy B