Wednesday 10 August 2016

Simple logic on rows to columns in sql server

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



No comments:

Post a Comment