A simple query
-
Hello, I have a table such as; (A and B are attribute names) A B - - 1 A 1 B 2 B 3 A 5 C 5 A I would like a query that returns me each distinct group of B column with its A column values. For instance; 1, 3, 5 > A 1, 2 > B 5 > C and I would like to be able to do something on each distinct group. (hope that I could be able to point my request) Sarp
-
Hello, I have a table such as; (A and B are attribute names) A B - - 1 A 1 B 2 B 3 A 5 C 5 A I would like a query that returns me each distinct group of B column with its A column values. For instance; 1, 3, 5 > A 1, 2 > B 5 > C and I would like to be able to do something on each distinct group. (hope that I could be able to point my request) Sarp
Hi there. Take a look at this article: http://www.sqlteam.com/item.asp?ItemID=2368[^] It describes using the COALESCE function to do something similar to what you're descibing.