Hi there.
I have a table with the following record structure:
ID TheGroup TheValue TheSubGroup
430093 47 MARQUEZ 1
430094 47 RAFAEL 1
430095 47 MONTREAL 1
430096 47 CANADA 1
430097 47 AMERICA 1
430113 47 MOORE 2
430114 47 ROBERT 2
430095 47 NAPLES 2
430096 47 FLORIDA 2
430097 47 AMERICA 2
.....
..... and so on
and I would like to get a subset of records looking like this
(grouped by TheSubGroup):
1 MARQUEZ RAFAEL MONTREAL CANADA AMERICA
2 MOORE ROBERT NAPLES CANADA AMERICA
.....
..... etc.
I do not know the number of rows that contains one 'blocks of records', but I do know that the returned subset WILL have the same number of rows per block
I can also limit it to a number lesser than 10 or 5 for that matter.
I am using MS SQL, but I expect it (I hope) to make it work in Oracle or DB2 also
Help will be much appreciated...
Thanks
I have a table with the following record structure:
ID TheGroup TheValue TheSubGroup
430093 47 MARQUEZ 1
430094 47 RAFAEL 1
430095 47 MONTREAL 1
430096 47 CANADA 1
430097 47 AMERICA 1
430113 47 MOORE 2
430114 47 ROBERT 2
430095 47 NAPLES 2
430096 47 FLORIDA 2
430097 47 AMERICA 2
.....
..... and so on
and I would like to get a subset of records looking like this
(grouped by TheSubGroup):
1 MARQUEZ RAFAEL MONTREAL CANADA AMERICA
2 MOORE ROBERT NAPLES CANADA AMERICA
.....
..... etc.
I do not know the number of rows that contains one 'blocks of records', but I do know that the returned subset WILL have the same number of rows per block
I can also limit it to a number lesser than 10 or 5 for that matter.
I am using MS SQL, but I expect it (I hope) to make it work in Oracle or DB2 also
Help will be much appreciated...
Thanks