Question
June 14, 2007 at 11:15 AM
webler

SELECT statement help

by webler . Updated 19 years, 2 months ago

Given this table:
select * from t1

c1 dt amt
1 Jan 10
1 Feb 20
1 Mar 30
1 Apr 40
1 May 50
2 Jan 11
2 Feb 21
2 Mar 31
2 Apr 41
2 May 51
3 Jan 12
3 Feb 22
3 Mar 32
3 Apr 42
3 May 52

Can someone show me the SELECT statement to get this result?

amt 1 amt 2 amt 3
Jan 10 11 12
Feb 20 21 22
Mar 30 31 32
Apr 40 41 42
May 50 51 52

Thanks

This discussion is locked

All Comments