ora-00904无效的标识符 [英] ora-00904 invalid identifier

问题描述

我的查询有问题...

I am having problem with my query...

此作品有效:

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

但是当我尝试使用'where'和group/having子句来获取所需的内容时，我收到了ora-00904(无效标识符)错误.

But when I try to get what I want using either the 'where' and group/having clause, I am getting a ora-00904 (invalid identifier) ERROR..

例如

  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?

推荐答案

尝试:

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

这篇关于ora-00904无效的标识符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！