I am very new to Informix Database and first time i am working on it.
I have one query in MySQL and try to execute in Informix database.
when i try to execute the below query in informix i am getting syntax error.
this query is working fine and returns optimistic result in mysql.
can you please help me out to execute the below query.
I don't know if it is a requirement that your query return only 1 row, but if it is not, then this might work for you:
select elementName, COUNT(*)
group by elementName
order by COUNT(*)
Also, it could be a cut & paste error or it is actually wrong in your query, but you have a typo in your constant:
Select count(1) Arabic_count
Where elementname = 'ArabicOpearator'
Probably should be 'ArabicOperator'
This is why you should have your elementNames in a different table and establish a relationship between vxmlelement and the new table.
You should not have these constants in your query. What happens when a new element name is added? What happens if an element name changes?
You are inviting a maintenance nightmare into your life! Just the small test case you posted had an error!