Retrieving All Columns
Instead of listing each column, you can use the asterisk *
to retrieve all columns from the table at once. This is especially useful when you need to view all the data in a table without manually typing out each column name. Hereβs an example:
SELECT * FROM table_name;
Task
Swipe to start coding
Write an SQL query to retrieve ALL columns from the country
table.
Solution
Everything was clear?
Thanks for your feedback!
SectionΒ 1. ChapterΒ 3