mysql group_concat issue

Question

I just trying to know is this possible the function of MYSQL GROUP_CONCAT to return this type of data. Here is a scenario

SELECT GROUP_CONCAT(marks) AS `i need only 40 int in this column`  FROM marks

when i execute this Query the result will be show like this

Result required 40

Answer 1

Try this:

select group_concat(m.marks) from 
    ( select distinct marks from marks limit 40 ) m