Oracle query with group by with result set?

Joseph K

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gokhul Varman9y ago
Please refer the link for more explanation:https://stackoverflow.com/questions/30712302/group-by-and-union-in-oracle
-1
Nilesh Shah9y ago
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
+1
Manikandan Murugesan9y ago
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
-1