Joseph K

Joseph K

  • NA
  • 255
  • 30.2k

Oracle query with group by with result set?

Jun 16 2017 9:36 AM
I have one requirement where the table will be like this

---------------------
Name | Amount |
---------------------
Raju | 2000 |
----------------------
Rajesh | 4000 |
----------------------
Raju | 4000 |
--------------------
Rajesh | 10000 |
----------------------

But i need a values where result set will be like this
------------------
Raju | Rajesh |
-----------------
6000 | 14000 |
---------------
 
 
when i tried group by it will result like this

-------------------
|Raju | 6000 |
-----------------
Rajesh | 14000 |
----------------- 
 
 
 

Answers (3)