Current data in employee table
| id | empid | sal_type | salary |
|---|---|---|---|
| 4 | 2 | var | 9000 |
| 3 | 2 | fixed | 5000 |
| 2 | 1 | var | 6000 |
| 1 | 1 | fixed | 10000 |
I need output as below
| empid | Fixed | VAR |
|---|---|---|
| 1 | 10000 | 6000 |
| 2 | 5000 | 9000 |
I tried to build select query but did not get output as expected
New contributor
Nimmi Mimlu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.