Forum Discussion
Transpose of Rows to Columns based on a column
There is a table presented below
| Employee_name | Department_name |
| A | IT |
| B | IT |
| C | CS |
| D | CS |
Expected output for the above table should look like
| Department_Name | Employee | Employee |
| IT | A | B |
| CS | C | D |
Possible way to write the SQL Query?
No RepliesBe the first to reply