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
Post a Comment