Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.SQL And, Or, Not | Database & Introduction to Syntax
SQL Tutorial for Beginners
course content

Conteúdo do Curso

SQL Tutorial for Beginners

SQL Tutorial for Beginners

1. Database & Introduction to Syntax
Meet the SQLSelect the Songs!SQL Select ColumnSQL DistinctSQL WhereChallenge WhereSQL And, Or, Not
2. SQL Aggregate Functions
SQL Min and MaxChallenge Min and MaxSQL Count, Sum, AvgChallenge Count
3. Filtering Statements
SQL NullSQL LikeChallenge LikeSQL BetweenSQL Order ByChallenge Order BySQL Group ByChallenge Group BySQL Top and LimitSQL AliasesSQL HavingChallenge HavingSQL Comments

bookSQL And, Or, Not

To combine multiple conditions, use AND, OR, and NOT keywords, and also brackets (, ) to set the priority.

For example, you want to select all songs' titles, that were produced between 1970 and 1990 years:


              
12

            
SELECT title FROM songs
WHERE year >= 1970 AND year <= 1990
copy

Or you can select all records where singer is not Pink Floyd:


              
12

            
SELECT * FROM songs
WHERE NOT singer = 'Pink Floyd'
copy

You can combine conditions for different columns, but not forget about brackets to define the priority:


              
12

            
SELECT * FROM songs
WHERE NOT (singer = 'Pink Floyd' AND price = 100)
copy

Tarefa

Find all songs titles and prices of 20th century, where the price is less than 500, or where the singer is AC/DC.

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 7
toggle bottom row

bookSQL And, Or, Not

To combine multiple conditions, use AND, OR, and NOT keywords, and also brackets (, ) to set the priority.

For example, you want to select all songs' titles, that were produced between 1970 and 1990 years:


              
12

            
SELECT title FROM songs
WHERE year >= 1970 AND year <= 1990
copy

Or you can select all records where singer is not Pink Floyd:


              
12

            
SELECT * FROM songs
WHERE NOT singer = 'Pink Floyd'
copy

You can combine conditions for different columns, but not forget about brackets to define the priority:


              
12

            
SELECT * FROM songs
WHERE NOT (singer = 'Pink Floyd' AND price = 100)
copy

Tarefa

Find all songs titles and prices of 20th century, where the price is less than 500, or where the singer is AC/DC.

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 7
toggle bottom row

bookSQL And, Or, Not

To combine multiple conditions, use AND, OR, and NOT keywords, and also brackets (, ) to set the priority.

For example, you want to select all songs' titles, that were produced between 1970 and 1990 years:


              
12

            
SELECT title FROM songs
WHERE year >= 1970 AND year <= 1990
copy

Or you can select all records where singer is not Pink Floyd:


              
12

            
SELECT * FROM songs
WHERE NOT singer = 'Pink Floyd'
copy

You can combine conditions for different columns, but not forget about brackets to define the priority:


              
12

            
SELECT * FROM songs
WHERE NOT (singer = 'Pink Floyd' AND price = 100)
copy

Tarefa

Find all songs titles and prices of 20th century, where the price is less than 500, or where the singer is AC/DC.

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!

To combine multiple conditions, use AND, OR, and NOT keywords, and also brackets (, ) to set the priority.

For example, you want to select all songs' titles, that were produced between 1970 and 1990 years:


              
12

            
SELECT title FROM songs
WHERE year >= 1970 AND year <= 1990
copy

Or you can select all records where singer is not Pink Floyd:


              
12

            
SELECT * FROM songs
WHERE NOT singer = 'Pink Floyd'
copy

You can combine conditions for different columns, but not forget about brackets to define the priority:


              
12

            
SELECT * FROM songs
WHERE NOT (singer = 'Pink Floyd' AND price = 100)
copy

Tarefa

Find all songs titles and prices of 20th century, where the price is less than 500, or where the singer is AC/DC.

Switch to desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
Seção 1. Capítulo 7
Switch to desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
some-alt