Hello All If I have a table with the following format
Table IPNumber IPClass DATA 0,10.10.10 1,10.10.10 2,10.10.10 3,10.10.10 7,10.10.10 8,10.10.10 9,10.10.10 20,10.10.10 21,10.10.10 I would like to have a select statement that would produce the following, which is the first number in a set and how many records are in that set. 0,4,10.10.10 7,3,10.10.10 20,2,10.10.10 Is this possible? Thanks for your knowledge Zaid Abdur-Rahman [EMAIL PROTECTED] --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
