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

Kursusindhold

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
Opgave

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.

Løsning

Switch to desktopSkift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder
Var alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 1. Kapitel 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
Opgave

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.

Løsning

Switch to desktopSkift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder
Var alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 1. Kapitel 7
Switch to desktopSkift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder
Vi beklager, at noget gik galt. Hvad skete der?
some-alt