Course Content
Introduction to SQL
Introduction to SQL
1. Retrieving Data
Retrieving Individual ColumnsRetrieving Multiple Columns Retrieving All ColumnsRetrieving Distinct RowsLimiting ResultsChallenge: Find the Population of the CountriesChallenge: Find All CountriesChallenge: Find All Countries With Their IDsChallenge: Find Country CapitalsChallenge: Find the Regions in Which All Countries Are Located
2. Sorting Retrieved Data
Sorting DataChallenge: Population SortSorting by Multiple ColumnsChallenge: Dual-Sort QuerySpecifying Sort DirectionChallenge: Sort the Countries by Region and CapitalChallenge: Sort Capitals in Descending OrderChallenge: Sort Countries in Ascending OrderChallenge: Find Countries, Their IDs, and Their PopulationsChallenge: Find Countries, IDs, Populations, Regions, and Sort ThemChallenge: Find All Continents and Sort Them in Ascending Order
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
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Thanks for your feedback!
SectionΒ 1. ChapterΒ 3
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
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Thanks for your feedback!
SectionΒ 1. ChapterΒ 3
Switch to desktop for real-world practiceContinue from where you are using one of the options below