sammybee77
Technical User
Hi All,
I'm trying to create the following view:-
create view blahblah
select max (id), field1, field2, field3
from table1
group by field1, field2, field3
When I try I get the following error:-
Error at line2
Ora-00998: must name this expression with a column alias
Where should I put my alias?
Many thanks
Sam
I'm trying to create the following view:-
create view blahblah
select max (id), field1, field2, field3
from table1
group by field1, field2, field3
When I try I get the following error:-
Error at line2
Ora-00998: must name this expression with a column alias
Where should I put my alias?
Many thanks
Sam