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
Partager
Partager
par
Dahmed22
KS3
Computing
Databases
Modifier le contenu
Sauvegarder
Aime
Imprimer
Incorporer
Plus
Affectations
Classement
Afficher plus
Afficher moins
Ce classement est actuellement privé. Cliquez sur
Partager
pour le rendre public.
Ce classement a été désactivé par le propriétaire de la ressource.
Ce classement est désactivé car vos options sont différentes pour le propriétaire de la ressource.
Rétablir les Options
Quiz
est un modèle à composition non limitée. Il ne génère pas de points pour un classement.
Connexion requise
Style visuel
Polices
Abonnement requis
Options
Plutôt comme ça
BASIC QUESTIONS IN ENGLISH
par
Colorfulenglish
Roue aléatoire
22
SMART CHOICE 2 UNIT 9 (WHILE vs WHEN)
par
Setubalteachers
Démêler
5
VOCABULARY RELATED TO INTERVIEW QUESTIONS
par
Thuha5
Apparier
5
BASIC QUESTIONS IN ENGLISH
par
Retosboxy
Roue aléatoire
5
When & While?
par
Lilytheteacher
Quiz
7
JOBS, MATCH THE COLUMNS
par
U65340072
Apparier
17
choose the correct column
par
Nk260106npa
Trier par groupe
14
Revision. Whilst, whereas and while
par
Cerysblackwitch
Cartes aléatoires
5
Changer de modèle
Afficher tout
Ouvrir les résultats
Copier le lien
Code QR
Supprimer
Restauration auto-sauvegardé :
?