Need output table like i mentioned below

Question

0.00/5 (No votes)

See more:

table
---------
ID	 Name	 subject	 marks

1  	Murugan	 tamil		66	
2	Raja	 tamil		82
3	Kumar	 tamil		74
4	Murugan	 English	71
5	Raja	 English	80
6	Kumar	English		69

i need this type output

Name 		tamil 		english

Murugan	 	66		71
Raja	 	82		80
Kumar		74		69

Posted 5-Jan-12 20:49pm

Prabhakara Pandian P

Updated 5-Jan-12 20:56pm

Mehdi Gholam

v2

Add a Solution

Comments

Sridhar Patnayak 6-Jan-12 6:33am

Dynamic creation of columns can be achieved by using pivot-table in sqlserver.
check this link http://blog.sqlauthority.com/2008/05/22/sql-server-pivot-table-example/. Your output can be achieved with pivot-table.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RDBurmon · Answer 1 · 2012-01-05T22:20:00

Try this

SQL

CREATE TABLE #tbl_Language
(
ID   BIGINT
,Name    NVARCHAR(50)
,subject     NVARCHAR(50)
,marks NVARCHAR(50)
)


INSERT INTO #tbl_Language
SELECT 1,'Murugan','tamil',66
 UNION ALL
SELECT 2,'Raja','tamil',82
 UNION ALL
SELECT 3,'Kumar','tamil',74
 UNION ALL
SELECT 4,'Murugan','English',71
 UNION ALL
SELECT 5,'Raja','English',80
 UNION ALL
SELECT 6,'Kumar','English',69


 SELECT Name ,tamil,English FROM
   (Select Name, Subject, marks FROM #tbl_Language F) P
   Pivot (MAX(Marks) For subject In (tamil,English)) as Pvt

dharan1990 · Answer 2 · 2012-06-29T00:30:00

SQL

select distinct(Obj1.Name),Obj2.Mark as 'Tamil',Obj3.Mark as 'English' from c Obj1 join c Obj2 on Obj1.Name=Obj2.Name and Obj2.Subject='Tamil' join c Obj3 on Obj1.Name=Obj3.Name and Obj3.Subject='English' order by Name

C is the Table Name.
Obj1,Obj2,Obj3 are all object of c.

Try this u vil get surely what u want....

Need output table like i mentioned below

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0