How to show output using following Data
HiHow to show this output any one guide me.
CREATE TABLE FinalRates
(
id int primary key identity(1,1),
RateDesc nvarchar(50),
Amt decimal(18,2)
)
insert into FinalRates values('100',200)
insert into FinalRates values('100',300)
insert into FinalRates values('50-80',100)
insert into FinalRates values('50-80',300)
insert into FinalRates values('30-50',500)
insert into FinalRates values('30-50',250)
SELECT * FROM FinalRates
-- i NEED OUTPUT THIS
RateDesc Amount1 Amount2
100 200 300
50-80 100 300
30-50 500 250