sqlite select all columns

gistfile1.txt

sqlite> create table students (name text, class text, height integer);
sqlite> insert into students values ('Haki', 'A', 186), ('Dan', 'A', 175), ('Jax', 'A', 182), ('George', 'B', 178), ('Bill', 'B', 167), ('David', 'B', 178);
sqlite> select *, max(height) as tallest from students group by class;
┌────────┬───────┬────────┬─────────┐
│  name  │ class │ height │ tallest │
├────────┼───────┼────────┼─────────┤
│ Haki   │ A     │ 186    │ 186     │
│ George │ B     │ 178    │ 178     │
└────────┴───────┴────────┴─────────┘