HELP ME TO GET SQL QUERY FOR BELOW RESULT
can you please solve my below sql query:-
Table_Name
Col1 Col2
CS 2009
CS 2010
EC 2010
EC 2009
EC 2008
IT 2006
CS 2007
CS 2013
IT 2009
IT 2008
EE 2009
EE 2010
Result:-
EE CS IT EC
2009 2009 2009 2009
2010 2010 2010 2010
2008 2013 2013 2013
2007 2007 2007 2007
2013 2008 2008 2008
PLEASE WRITE SQL QUERY TO GET ABOVE RESULT....
Table_Name
Col1 Col2
CS 2009
CS 2010
EC 2010
EC 2009
EC 2008
IT 2006
CS 2007
CS 2013
IT 2009
IT 2008
EE 2009
EE 2010
Result:-
EE CS IT EC
2009 2009 2009 2009
2010 2010 2010 2010
2008 2013 2013 2013
2007 2007 2007 2007
2013 2008 2008 2008
PLEASE WRITE SQL QUERY TO GET ABOVE RESULT....
Replies
-
Vishal SharmaOh my god!! a home work!
I never did mine! 😲 -
Sanyam KhuranaCould you please write this with proper formatting, it would help me, to better understand this stuff and could help you?
-
Neeraj SharmaI am kinda puzzled with the output that you want to attain. Can you please try and re check the question and post may be an image for us to understand clearly and help you better?
You are reading an archived discussion.
Related Posts
CEans,
When CrazyEngineers began its journey back in 2005; people hesitated using their real names online. That's why most of the community boards would have nick names. For the records...
Acer Liquid S2 is world's first phone with 4K video recording abilities. The company announced that Liquid S2 has a 6" IPS display with Gorilla Glass 3. Note that the...
2014-Porsche Panamera is on the news recently because The legendry sports car maker had planned to introduce Panamera facelift 2014 in the upcoming Frankfurt auto Show. The facelift is expected...
Its non other than Jaguar a Tata owned luxury , sports car company to tease the C-X17 SUB concept ahead of the Frankfurt autoshow . The Jaguar is an established...
Micromax, India's favorite Android budget phone maker, is here with a new smartphone. With the launch of Micromax A74 Canvas Fun, it has brought to the Indian market a phone...