Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Learn Retrieving All Columns | Retrieving Data
Introduction to SQL with output checkers

bookRetrieving 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:


              
12

            
SELECT * 
FROM table_name;
copy
Task

Swipe to start coding

Write an SQL query to retrieve ALL columns from the country table.

Solution

Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 1. ChapterΒ 3
single

single

Ask AI

expand

Ask AI

ChatGPT

Ask anything or try one of the suggested questions to begin our chat

Suggested prompts:

Can you explain when it's better to use `SELECT *` versus specifying column names?

Are there any drawbacks to using `SELECT *` in SQL queries?

Can you show an example with specific column names instead of `*`?

close

Awesome!

Completion rate improved to 2.44

bookRetrieving All Columns

Swipe to show menu

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:


              
12

            
SELECT * 
FROM table_name;
copy
Task

Swipe to start coding

Write an SQL query to retrieve ALL columns from the country table.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

close

Awesome!

Completion rate improved to 2.44
SectionΒ 1. ChapterΒ 3
single

single

some-alt