Sql column as header

You simply need to us the "as" statement to rename an existing column or result.
> select name, max(age) as old from People
> Result:
> name		|	old
> Steven	|	72

Similar codes

0 vote274 views1 answer
Check connections to database postgres
SQL
0 vote274 views1 answer
Sql put two columns into one
SQL
0 vote285 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
11 votes285 views1 answer
Oracle insert from select
SQL
0 vote263 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote284 views1 answer
Sql select column name like from multiple tables
SQL
0 vote264 views1 answer
Utiliser sql ligne de commande
SQL
0 vote283 views1 answer
How to print some string in mysql
SQL
0 vote286 views1 answer
Calculate age in sql
SQL
0 vote266 views1 answer
Restart sql server command line linux
SQL