convert rows to columns

[Pallavit10]

Hi All,

I want following o/p in oracle & sql server

a table contains data as given

name exam marks
-------- -------- -----------
Test Phy 30
Test Chm 40
Test Eng 50
XYZ Eng 50
XYZ Mat 11
XYZ SS 10
XYZ Phy 40


Final O/p ->

Name Sub1 mark1 sub2 mark2 sub3 mark3 sub4 mark4
-------- -------- -------- --------- -------- ------- --------- -------- --------
Test Phy 30 Chm 40 Eng 50
XYZ Eng 50 Mat 11 SS 10 Phy 40


pls send me query

[ashishthakre]

Hi All,

I want following o/p in oracle & sql server

a table contains data as given

name exam marks
-------- -------- -----------
Test Phy 30
Test Chm 40
Test Eng 50
XYZ Eng 50
XYZ Mat 11
XYZ SS 10
XYZ Phy 40


Final O/p ->

Name Sub1 mark1 sub2 mark2 sub3 mark3 sub4 mark4
-------- -------- -------- --------- -------- ------- --------- -------- --------
Test Phy 30 Chm 40 Eng 50
XYZ Eng 50 Mat 11 SS 10 Phy 40


pls send me query

hi Please find the query below

select name
, max (case exam when 'Chm' then exam end) as Sub1
, max (case exam when 'Chm' then marks end) as Mark1
, max (case exam when 'Eng' then exam end) as Sub2
, max (case exam when 'Eng' then marks end) as Mark2
, max (case exam when 'Mat' then exam end) as Sub3
, max (case exam when 'Mat' then marks end) as Mark3
, max (case exam when 'Phy' then exam end) as Sub4
, max (case exam when 'Phy' then marks end) as Mark4
, max (case exam when 'SS' then exam end) as Sub5
, max (case exam when 'SS' then marks end) as Mark5
from t
group by name;

[frozenmist]

Hi,
Please read through the Posting Guidelines before posting.
Please don't ask for the query unless you have tried it out and have posted your version of the query.
The experts are more than happy to help you out with your queries, but you should post your attempt first.
Please be careful in future.

Thanks,
MODERATOR