SQL question

[Erdenemandal]

Hi, ALL

 

I have a questin concerning SQL query .

 

This is my main query

 

SELECT O.* FROM organization O LEFT OUTER JOIN  moreinfo M ON O.oi_moreinfoid = M.mis_moreinfoid WHERE UPPER(O.ox_organname) LIKE '%SIGNAL%' ORDER BY O.ox_organname LIMIT 50 OFFSET 0

 

It works , but I want to use this query with count(o.*) . But it gives me error

 

query

SELECT Count(O.*) FROM organization O LEFT OUTER JOIN  moreinfo M ON O.oi_moreinfoid = M.mis_moreinfoid WHERE UPPER(O.ox_organname) LIKE '%SIGNAL%' ORDER BY O.ox_organname LIMIT 50 OFFSET 0

 

ERROR is

ERROR:  Attribute o.ox_organname must be GROUPed or used in an aggregate function

 

 

Please help me. What could I do

 

THANKS,

Erdenemandal

[Erdenemandal]

This Works

 

SELECT Count(O.*) FROM organization O LEFT OUTER JOIN moreinfo M ON O.oi_moreinfoid = M.mis_moreinfoid GROUP BY UPPER(O.ox_organname) LIKE '%SIGNAL%'

[kejpa]

If you want to count ALL rows where UPPER(O.ox_organname) LIKE '%SIGNAL%' and not split on individual organnames use...

SELECT Count(O.*) FROM organization O LEFT OUTER JOIN moreinfo M ON O.oi_moreinfoid = M.mis_moreinfoid HAVING UPPER(O.ox_organname) LIKE '%SIGNAL%'

 

HTH

Kejpa