5.5.09

Simple logic on rows to columns in sql server

Problem statement :
Am having data in rows and I need to customize into columns.
How to group the data in different format?

create table venkatTable(subject varchar(10),marks int,Gender varchar(10))
insert into venkatTable values('Maths',50,'F')
insert into venkatTable values('Maths',20,'M')
insert into venkatTable values('English',50,'F')
insert into venkatTable values('English',30,'M')
insert into venkatTable values('Physics',50,'F')
insert into venkatTable values('Physics',70,'M')
select * from venkatTable


select distinct a.subject,M =
(select marks from venkattable where subject=a.subject and gender='M')
,F= (select marks from venkattable where subject=a.subject and gender='F')
from venkattable a

Thanks and Regards,
Venkatesan Prabu .J

No comments:

Post a Comment