Challenge: Find All Countries With Their IDs
Definition
In most databases, the id
column acts as a unique identifier, often referred to as a primary key, for each record. By selecting both the id
and name
columns, you can view the unique identifier linked to each country. This is crucial for associating records or when you need to reference specific entries in the database.
Task
Swipe to start coding
Write an SQL query to get all the country name
values and their id
values.
Solution
Everything was clear?
Thanks for your feedback!
SectionΒ 1. ChapterΒ 8