mysql - Get average of a column at end of row -


i have following table:

name height    20 b    30 c    40 

i need following output in mysql follows: name   height
          20
b           30
c           40

average   30

the output should appear @ end of result of table.

you can rollup , trick:

select name, avg(height) height table t group name rollup; 

Comments