Which keywords are used in SQL?, SELECT, FROM, WHAT, WHERE, WHILE, GRAB, Which keywords cannot be used in SQL?, SELECT, FROM, WHAT, WHERE, WHILE, GRAB, Which SQL statement is correct? Write an SQL statement to retrieve the FirstName and LastName from the table Customers who live in the city of 'London'., SELCT FirstName, LastName FROM Customers WHERE City EQUALS 'London';, SELECT FirstName, LastName FROM Customers WHERE City = 'London';, Which SQL statement is correct? Write an SQL statement to retrieve the ProductName and Price of all products that belong to the 'Electronics' category and have a StockQuantity greater than 50., SELECT ProductName, Price WHERE Category = 'Electronics' AND StockQuantity > 50;, SELECT ProductName, Price FROM Products WHERE Category = 'Electronics' OR StockQuantity > 50;, SELECT ProductName, Price FROM Products WHERE Category = 'Electronics' AND StockQuantity > 50;, SELECT Product_Name, Price FROM Products WHILE Category = 'Electronics' AND StockQuantity > 50;, What do we place after the word SELECT?, The name of the table, The name of the column we want to select, The condition we want to get information based on., What do we place after the word FROM?, The name of the table, The name of the column we want to select, The condition we want to get information based on., What do we place after the word WHERE?, The name of the table, The name of the column we want to select, The condition we want to get information based on.
0%
SQL Starter
Del
Del
etter
Dahmed22
KS3
Computing
Databases
Rediger innhold
Lagre
Som
Skriv ut
Innebygd
Mer
Tildelinger
Ledertavle
Vis mer
Vis mindre
Denne ledertavlen er for øyeblikket privat. Klikk
Share
for å gjøre den offentlig.
Denne ledertavlen er deaktivert av ressurseieren.
Denne ledertavlen er deaktivert fordi alternativene er forskjellige fra ressurseieren.
Alternativer for tilbakestilling
Spørrelek
er en åpen mal. Det genererer ikke poengsummer for en ledertavle.
Pålogging kreves
Visuell stil
Skrifter
Krever abonnement
Alternativer
Mer som dette
BASIC QUESTIONS IN ENGLISH
etter
Colorfulenglish
Tilfeldig hjul
22
SMART CHOICE 2 UNIT 9 (WHILE vs WHEN)
etter
Setubalteachers
Løse opp
5
VOCABULARY RELATED TO INTERVIEW QUESTIONS
etter
Thuha5
Match opp
5
BASIC QUESTIONS IN ENGLISH
etter
Retosboxy
Tilfeldig hjul
5
When & While?
etter
Lilytheteacher
Spørrelek
7
JOBS, MATCH THE COLUMNS
etter
U65340072
Match opp
17
choose the correct column
etter
Nk260106npa
Gruppe sortering
14
Revision. Whilst, whereas and while
etter
Cerysblackwitch
Tilfeldige kort
5
Bytt mal
Vis alle
Åpne resultater
Kopier kobling
QR-kode
Slette
Gjenopprett automatisk lagring:
?
