basic doubt

[subash2511]

Is it possible to use group by without aggregate function in general..

[debasisdas]

Is it possible to use group by without aggregate function in general..

If there is no aggregate function then why you need to group the records ?

[AdusumalliGopikumar]

Hi,

If you want use Group by Clause in your query then you must and should use any of the aggregate function.

or else system will throw an error message like

ORA-00979 :not a GROUP BY expression.