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

Kurssisisältö

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

book
SQL 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
Tehtävä

Swipe to start coding

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

Ratkaisu

Switch to desktopVaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoista
Oliko kaikki selvää?

Miten voimme parantaa sitä?

Kiitos palautteestasi!

Osio 1. Luku 7
toggle bottom row

book
SQL 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
Tehtävä

Swipe to start coding

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

Ratkaisu

Switch to desktopVaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoista
Oliko kaikki selvää?

Miten voimme parantaa sitä?

Kiitos palautteestasi!

Osio 1. Luku 7
Switch to desktopVaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoista
Pahoittelemme, että jotain meni pieleen. Mitä tapahtui?
some-alt