ora-09004 invalid identifier

Question

hello,

i am having problem with my query...

this one works..

  select name, bday, address, dbms_random.value(1, 100) as joker
  from employee order 
  by joker asc

but when i try to get what i want using either the 'where' and group/having clause, i am having a ora-09004 (invalid identifier) ERROR..

e.g.

 select name, bday, address, dbms_random.value(1, 100) as joker 
 from employee where joker>5 
 order by joker asc

 select name, bday, address, dbms_random.value(1, 100) as joker
 from employee group by name, bday, address 
 having joker>5 order by joker asc 

what could be my problem here and how can i query using the joker column...

TIA.

Answer 1

try:

Select * from
(select name, bday, address, dbms_random.value(1, 100) as joker 
from employee)
where joker>5 
order by joker asc