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

GROUP BY year


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

Comentarios


bottom of page