Exploring Data with SQL

https://www.codecademy.com/paths/data-science/tracks/dspath-why-data-python-basics/modules/dspath-intro-data-science/lessons/why-data-science/exercises/sql

Hi everyone,

I wanted to ask a very basic question about querying data using SQL.

In one of the first lessons under the data science course, I was asked to run the following code.

SELECT *
FROM browse
LIMIT 10;

Note: ’ This code will select all ( * ) columns from browse table for the first 10 records.’

My question is, what’s a (’*’) column?

Thanks in advance!

Hello @viciouscode, welcome to the forums! In SQL, the * character is a wildcard-in a sense-it means all, so SELECT * means “select all”:

SELECT *
FROM TABLE_1;

Means “select every column from TABLE_1”.

I hope this helps!

I see! Thank you very much for the enlightenment! :slight_smile:

1 Like

This topic was automatically closed 41 days after the last reply. New replies are no longer allowed.