How to convert long data to wide data without hard coding in SQL?

If any one please help me.

Regards Manish Bose

  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.
    – Community Bot
    Dec 16, 2022 at 5:28
  • Do you mean splitting data in chunk? Dec 16, 2022 at 10:04
  • Ready-to-use pivotting stored procedure: stackoverflow.com/a/66136355/10138734
    – Akina
    Dec 16, 2022 at 10:57
  • Another stored proc for pivoting: mysql.rjweb.org/doc.php/pivot -- If "pivoting is how what you need, then elaborate.
    – Rick James
    Dec 16, 2022 at 18:44


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.