sql help(rows to columns) - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

sql help(rows to columns)

swaggerswagger Posts: 1Member
pl help

Table1 : Student(stu_id,studentname)

Table2 : Subjects(sub_id,subjectname)

Table3 : marks(marks_id,stu_id,sub_id,mark)

I need an sql query to display the output as follows:

name englsih maths science
qqwe 22 33 44
wqwe 55 11 33
rqwe 34 66 77
Sign In or Register to comment.