Why doesn't this work?

This query works in SQLPlus:

select name, count(name)
from emp
group by name
order by count(name) desc;

But why doesn't this work:

create view v as
select name, count(name)
from emp
group by name
order by count(name) desc;

I thought views were just stored queries. So if the first one works why doesn't the second work? Received on Sun Dec 13 1998 - 00:35:33 CST