top of page

Rename Column in SQL

Updated: May 1

rename column in sql

To rename column in SQL.

SQL allows us to rename columns by using the AS operator.Try replacing COUNT(*) with the following to rename that calculated column as prize_count: COUNT(*) AS prize_count

Answer: SELECT year, COUNT (*) AS prize_count

FROM nobel_prizes


Ready to become a SQL wizard in record time? Dive into the world of databases with our SQL bootcamp!

Whether you're a complete beginner or looking to brush up on your skills, "Mastering SQL" is your ticket to proficiency.

57 views0 comments


bottom of page