from this STU SUB 1 MAT 1 CHEM 1 PHY to this STU SUB1 SUB2 SUB3 1 MAT CHEM PHY data of 1 student is in 3 rows i want in 1 row in sql

Hello jihok Please use this query and you can convert your result WITH RankedSubjects AS ( SELECT STU SUB ROW_NUMBER() OVER (PARTITION BY STU ORDER BY SUB) AS RowNum FROM YourTable ) SELECT STU [1] AS SUB1 [2] AS SUB2 [3] AS SUB3 FROM RankedSubjects PIVOT ( MAX(SUB) FOR RowNum IN ([1] [2] [3]) ) AS PivotTable;

Try this: SELECT STU [MAT] AS SUB1 [CHEM] AS SUB2 [PHY] AS SUB3 FROM (SELECT STU SUB FROM your_table_name) AS SourceTable PIVOT (MAX(SUB) FOR SUB IN ([MAT] [CHEM] [PHY])) AS PivotTable;

Answers

data of 1 stu is in 3 rows i want in 1 row in sql

Guest User

159

from this

STU	SUB
1	MAT
1	CHEM
1	PHY

to this

STU	SUB1	SUB2	SUB3
1	MAT	CHEM	PHY

data of 1 student is in 3 rows i want in 1 row in sql

Answers (2)

Next Recommended Forum

Declaring multiple string parameter in declare and set variable

Group By Error

Leaderboard

View all

Shubhankar Banerjee

Magnus Mårtensson

Bhasker Das

View all

Yesterday's leader

Shubhankar Banerjee

Blockchain, Solidity, Polygon, C#, NodeJS, HTML, C Language, C++, JavaScript, CSS, ReactJS, MySQL

Kanpur (India)

164

113.7k

11.3k

500

Member of the month

Mark Pelf

Belgrade (Yugoslavia)

187

283.4k

10.4k

500

Speaker of the month

Magnus Mårtensson

ASP.NET, .NET, C#, JavaScript, Azure

Sweden

17.2k

56.5k

Upcoming events

View all

Suggested for you

View all

Datis Almaspoor

Prathap Reddy

Kanishk Kumar

Sangeetha S

Harshit Pandey

Forum Statistics

Please welcome our newest member Manish Dahiya .
3,075,401 users have contributed to 147,419 threads and 483,388
In the past 24 hours, we have 10 new threads, 28 new posts, and 200 new users.
In last week, the most popular thread is 'Query result in HTML format'.