i want sasmahi means 6th term result n salana means yearly result i want to achieve something like this salana 50 salana 50 salana 50 salana 50 sasmahi 50 sasmahi 50 sasmahi 50 sasmahi 50 i want in different columns salana sashmahi 50 50 50 50 50 50 50 50 with subject and other fields.

Hello Munir Try this create table tbl12 (Id int,name varchar(50),trm int) insert into tbl12 values(5,'sasmahi ',50) insert into tbl12 values(6,'sasmahi ',50) insert into tbl12 values(7,'sasmahi ',50) insert into tbl12 values(8,'sasmahi ',50) SELECT salana ,sasmahi FROM (SELECT name, trm FROM tbl12 )Tab1 PIVOT ( SUM(trm) FOR Name IN (salana,sasmahi)) AS Tab2 ORDER BY Tab2.salana

That can be solved by using pivot and unpivot relational operator. Here you can convert column to rows and vice versa. https://docs.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot?view=sql-server-2017