Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SQL Query Expand / Collapse
Author
Message
Posted Sunday, July 28, 2013 6:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, July 28, 2013 11:01 AM
Points: 6, Visits: 8
Thank you SSC Enthusiastic, I got it What i want
Post #1478354
Posted Sunday, July 28, 2013 6:25 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 3:20 AM
Points: 196, Visits: 650
ChrisM@home (7/28/2013)

I think you need another edit

Edit: beat me to it.


Ha



Dird // Junior DBA
11g OCA
10.5 newbie
Post #1478355
Posted Sunday, July 28, 2013 6:26 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:48 AM
Points: 36,759, Visits: 31,214
vshiva2379 (7/28/2013)
Thank you, But Sorry I didnt Get my result with that
My table is
Student

StudentID int,
name varchar(20),
maths int,
science int,
comp int

records are

1, Allen, 60, 80,75
2, John ,70,60,90
3, Kim, 86,85, 80

result should be

Allen science
John comp
Kim maths

Thank you


I'm thinking that you didn't actually read the article at the first link in my signature line below. And I agree with Chris. This looks like coursework (especially since the data is so badly denormalized). Please show us what you've tried. This should be a learning experience, not a hand out. And take the time to post the data in the readily consumable format identified in the article. That article will also teach you a couple of neat tricks in SQL


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1478356
Posted Sunday, July 28, 2013 6:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, July 28, 2013 11:01 AM
Points: 6, Visits: 8
Sorry Jeff , That was my mistake i didnt give correct details,

Thanks allot for your valuable time
Post #1478357
Posted Sunday, July 28, 2013 6:31 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:48 AM
Points: 36,759, Visits: 31,214
vshiva2379 (7/28/2013)
Execuse me

Since you did not understand i how given that data and more over i do not want to disclose my original data i have given that, if you insist then have a look

Create table Student(Studentid int,name varchar(50),maths int,science int,com int)

insert into Student values(1,'Allen',40,50,89)
insert into Student values(2,'John',70,90,89)
insert into Student values(1,'Nick',90,80,89)

Thank you


Heh... if I insist. It's your question, bud. Look how fast people responded when you posted it in a readily consumable format.

The question now is, do you actually understand the code that gave you the desired answer?


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1478358
Posted Sunday, July 28, 2013 6:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, July 28, 2013 11:01 AM
Points: 6, Visits: 8
I am very Sorry about that but i was bit worried with the query i was not getting, Thanks allot to every one, I got my answer and i have completed my work
Post #1478360
Posted Sunday, July 28, 2013 9:03 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:48 AM
Points: 36,759, Visits: 31,214
vshiva2379 (7/28/2013)
I am very Sorry about that but i was bit worried with the query i was not getting, Thanks allot to every one, I got my answer and i have completed my work


No problem. The question remains, though... do you understand the solution?


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1478434
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse