Member Avatar for saadi06

Hi,
I have a question that can we use a mysql query in Concat clause. I want to make a query like this

 SELECT CONCAT(AVG(value),'-',(select Count(UserId) as counts from user_details )) as `Average` from surveyuseranswer

Now I want to count number of users and concat it with the average value. My query runs but it returns me nothing. Can anyone help me that where I am wrong.
Thanks in advance.

Edited by pritaeas because: Moved.
  • 2 Contributors
  • 3 Replies
  • 130 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by dcdruck
Member Avatar for dcdruck

I think you should be able to do that. Are you getting an error or just an empty resultset?

Member Avatar for saadi06

I am getting an empty result but no error.I wanted to know that why the result is coming empty because the result should not be empty as there I run the count query alone it displays me the count number.

Member Avatar for dcdruck

What if you run the outer query alone without the inner query? Do you get results then?

SELECT AVG(value) as `Average` from surveyuseranswer
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.