How to select same column data as different rows in SQL

Question

Using SQL Select Query with the table of following structure

Id  Name  Subject

07  anu   Maths
07  anu   English
07  anu   Hindi

I want the Result as

Id Name Sub1    Sub2     Sub3
07 Anu  Maths   English  Hindi

Welcome to Stack Overflow. This is not a good way to ask a question here. Did you try anything so far to solve your problem? Show your effort first so people might show theirs. Please read FAQ, How to Ask and help center as a start.. — Soner Gönül
– Soner Gönül, Commented May 29, 2014 at 12:00

r.vengadesh · Accepted Answer · 2014-05-29 12:41:57Z

1

Try this it will help you

SELECT Name,
      MAX(CASE WHEN Subject = 'Maths' THEN Subject ELSE NULL END) [subject1],
      MAX(CASE WHEN Subject = 'English' THEN Subject ELSE NULL END) [subject2],
      MAX(CASE WHEN Subject = 'Hindi' THEN Subject ELSE NULL END) [subject3]
FROM Subject
GROUP BY Name

edited May 29, 2014 at 12:41

answered May 29, 2014 at 12:03

r.vengadesh

1,8373 gold badges21 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Soner Gönül Over a year ago

meta.stackexchange.com/questions/8231/…

Soner Gönül Over a year ago

No needed. Would be better as an example solution for question instead of just a link ;)

Collectives™ on Stack Overflow

How to select same column data as different rows in SQL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related