1 Replies - 237 Views - Last Post: 08 August 2017 - 01:34 PM

#1 ikhlas06  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 171
  • Joined: 20-May 16

error: "GROUP_CONCAT": invalid identifier

Posted 08 August 2017 - 12:04 PM

I have this oracle table

----------------------------------
| KEY | pKEY | color | name      | 
-----------------------------------
| 1   | 20   | red   | test      |
| 1   | 20   | green | test      |
| 2   | 20   | red   | test      |



I want this:

---------------------------------------
| KEY | pKEY | color      | name      | 
----------------------------------
| 1   | 20   | red-green  | test      |
| 2   | 20   | red        | test      |



select KEY, pKEY, color, GROUP_CONCAT(name)
from myTable 
where pKEY = 20
group by key, pkey, color, name


error: "GROUP_CONCAT": invalid identifier

Is This A Good Question/Topic? 0
  • +

Replies To: error: "GROUP_CONCAT": invalid identifier

#2 andrewsw  Icon User is offline

  • lashings of ginger beer
  • member icon

Reputation: 6340
  • View blog
  • Posts: 25,570
  • Joined: 12-December 12

Re: error: "GROUP_CONCAT": invalid identifier

Posted 08 August 2017 - 01:34 PM

GROUP_CONCAT is not an Oracle function, it exists in MySQL.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1