rotation table in 90 degree - help

Hi,

I need to create a view that looks like a 90 degree rotation of the original table.
for example: say my table looks like:

A      B
1      100
2      500
3      150
2      300
2      350
1      200

then my view should look something like: 1 100 200
2 500 300 350
3 150

I cant know how many rows in the table contain the same A data. can I create a view like this?

thanks alot
Ori Received on Fri Feb 15 2002 - 02:35:13 CST