Oracle query with group by with result set?

Question

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 |
-----------------

Nilesh Shah · Answer

Hi you will have to use PIVOT in oracle refer this link pls: https://blogs.oracle.com/sql/how-to-convert-rows-to-columns-and-back-again-with-sql-aka-pivot-and-unpivot#pivot

Gokhul Varman · Answer

Please refer the link for more explanation:https://stackoverflow.com/questions/30712302/group-by-and-union-in-oracle

Manikandan Murugesan · Answer

You can use tha Aggregate Functions. In database management an aggregate function is a function where the values of multiple rows are grouped together as input on certain criteria to form a single value of more significant meaning or measurement such as a set a bag or a list. Common aggregate functions include : Average() (i.e. arithmetic mean) Count() Refer this link : https://docs.oracle.com/database/121/SQLRF/functions003.htm#SQLRF20035