Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Sql query assistance

Author  Topic 

vignesht50
Yak Posting Veteran

82 Posts

Posted - 2014-03-07 : 01:17:11
This is my table

Dept Name Subject

CSE Paul C
ECE Mark C++
CSE Paul DSP
AERO Steve Aerodynamics
ECE Ben Electrical
CSE Mark C++
AERO Ben Astrophysics


Expected Output:

Dept Name Subject

CSE Paul C
CSE Paul DSP
CSE Mark C++
ECE Mark C++
ECE Ben Electrical
AERO Ben Astrophysics
AERO Steve Aerodynamics

Can anyone help me solve this.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2014-03-07 : 01:23:21
What are you trying to do here ?

Can you kindly explain ?


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -