CrazyEngineers
  • sarangc

    sarangc

    MemberSep 1, 2013

    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....
    Replies
Howdy guest!
Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.
Replies
  • Vishal Sharma

    MemberSep 2, 2013

    Oh my god!! a home work!
    I never did mine! 😲
    Are you sure? This action cannot be undone.
    Cancel
  • Sanyam Khurana

    MemberSep 2, 2013

    Could you please write this with proper formatting, it would help me, to better understand this stuff and could help you?
    Are you sure? This action cannot be undone.
    Cancel
  • Neeraj Sharma

    MemberSep 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?
    Are you sure? This action cannot be undone.
    Cancel
Home Channels Search Login Register