Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Aprenda How many? | Selecting
SQL Basics

Deslize para mostrar o menu

book
How many?

What if you want to know the exact number of observations in your database? Counting manually sounds like a very very bad idea.

Fortunately, SQL has the built-in functionality of counting rows. To count the number of rows in the whole dataset use COUNT *. For example, we can count the total number of our website being visited by using the following query:

12
SELECT COUNT(*) FROM visitors
copy

Please note, that for counting the total number of rows you must place * within parenthesis, like COUNT(*).

Tarefa

Swipe to start coding

Count number of Audi cars sold from audi_cars table.

Solução

Switch to desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

Seção 1. Capítulo 6
single

single

Pergunte à IA

expand

Pergunte à IA

ChatGPT

Pergunte o que quiser ou experimente uma das perguntas sugeridas para iniciar nosso bate-papo

close

Awesome!

Completion rate improved to 2.63

book
How many?

What if you want to know the exact number of observations in your database? Counting manually sounds like a very very bad idea.

Fortunately, SQL has the built-in functionality of counting rows. To count the number of rows in the whole dataset use COUNT *. For example, we can count the total number of our website being visited by using the following query:

12
SELECT COUNT(*) FROM visitors
copy

Please note, that for counting the total number of rows you must place * within parenthesis, like COUNT(*).

Tarefa

Swipe to start coding

Count number of Audi cars sold from audi_cars table.

Solução

Switch to desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

close

Awesome!

Completion rate improved to 2.63

Deslize para mostrar o menu

some-alt