Database Administration (MOSC)

MOSC Banner

Aggregate query

edited May 23, 2010 10:24PM in Database Administration (MOSC) 2 commentsAnswered
Hi,      Lets say I have query like the following:

select x.*, y.id, sum(y.amount)

from x, y

where x.id = y.id 

group by x.*, y.id;

x.* in group by does not work. How to make it work? The table x has lot of columns so I have to use x.*.

Thanks a lot,

Arun

 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center