Rotate SQL tables

 I need rotate a relative big table (~100K rows)

The source table:

idenvdate
1yahoo1/1/3
2igoogle1/1/4
3vista1/2/4
4igoogle1/1/2
5iphone12/12/02

 

Target table or query result set must be:

  iphoneigoogleyahoovista
  1211

 

I need (in single SELECT) count rows grouping by 'env' and create result as shown before.

Any ideas?

 

Thank you for your interest!

We will contact you as soon as possible.

Send us a message

Oops, something went wrong
Please try again or contact us by email at info@tikalk.com