Is below possible in SQL by using view? how?

  Kiến thức lập trình

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.