Wednesday, April 25, 2007

How to use MySQL Aggregate Function GROUP_CONCAT()

Few days ago, I got a mail from one of my friend. The mail was asking a question like below:-

Answer the following question within 10 sec and without the help of a calculator.

If 1 = 5, 2 = 25, 3 = 625, 4 = 390625, then 5 = ?

Answer is hidden here

I asked this question to some other friends. They also replied the wrong answer. The answer is very simple. But sometimes we make complex and wrong solutions of simple problems. This happens due to lack of proper understanding the 'system'.

Here is similar problem, which occurs frequently in our day to day programming.

Let you have team_member table data like below:-

1 comment:

Anonymous said...

Useful Information. Thanks Ron