HELP ME TO GET SQL QUERY FOR BELOW RESULT

@sarangc-PJCGdF • Oct 26, 2024

Oct 26, 2024

1.4K

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....

Like 0 Replies 3

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

CrazyEngineers powered by Jatra Community Platform

Vishal Sharma

@vishal-pysGmK • Sep 2, 2013

Oh my god!! a home work!
I never did mine! 😲

0
Sanyam Khurana

@sanyam-Nl7Zqc • Sep 2, 2013

Could you please write this with proper formatting, it would help me, to better understand this stuff and could help you?

0
Neeraj Sharma

@neeraj-iAaNcG • Sep 2, 2013

I 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?

0