MallikarjunSM
New User
Joined: 22 Sep 2018 Posts: 1 Location: India
|
|
|
|
I have a Table as Below
EmpNum EmpName SalType Salary
100 Raja fixed 50,000
100 Raja variable 80,000
200 Rani fixed 60,000
300 Guru variable 100,000
Expected result
EmpName Salary Salary
Raja 50,000 80,000
The Instances of Raja can be more.
I have to fetch all the instances of salaries of the said employee.
I am unable to write a DB2 query for this.
Please help me. |
|