How to Select and Order By columns not in Groupy By SQL statement - Oracle
I have the following statement:

    SELECT  
    	IMPORTID,Region,RefObligor,SUM(NOTIONAL) AS SUM_NOTIONAL
    From 
    	Positions
    Where
    	ID = :importID
    GROUP BY 
    	IMPORTID, Region,RefObligor
    Order BY 
    	IMPORTID, Region,RefObligor

There exists some extra columns in table `Positions` that I want as output for "display data" but I don't want in the group by statement.

These are `Site, Desk`

Final output would have the following columns:

    IMPORTID,Region,Site,Desk,RefObligor,SUM(NOTIONAL) AS SUM_NOTIONAL

Ideally I'd want the data sorted like:

    Order BY 
    	IMPORTID,Region,Site,Desk,RefObligor

How to achieve this?
How to Select and Order By columns not in Groupy By SQL statement - Oracle
===

I have the following statement:

    SELECT  
    	IMPORTID,Region,RefObligor,SUM(NOTIONAL) AS SUM_NOTIONAL
    From 
    	Positions
    Where
    	ID = :importID
    GROUP BY 
    	IMPORTID, Region,RefObligor
    Order BY 
    	IMPORTID, Region,RefObligor

There exists some extra columns in table `Positions` that I want as output for "display data" but I don't want in the group by statement.

These are `Site, Desk`

Final output would have the following columns:

    IMPORTID,Region,Site,Desk,RefObligor,SUM(NOTIONAL) AS SUM_NOTIONAL

Ideally I'd want the data sorted like:

    Order BY 
    	IMPORTID,Region,Site,Desk,RefObligor

How to achieve this?