Select * from t1;
ID NAME SALARY
----- ------- ----------
1 ABC 5000
1 ABC 10000
2 DEF 20000
2 DEF 30000
Output:
---------
ID Name Salary1 Salary2
--- ------ -------- --------
1 ABC 5000 10000
2 DEF 20000 30000
Can anyone please solve this query by using pivot operator or any other method. Please!