Find all fields for people called FRED - Select * from People where firstname = "FRED", Field - A single piece of data about someone or something, Record - A collection of fields about someone or something, Find firstname of people with an age above 25 - Select Firstname from People where age > 25, Find firstname of people with an age of 25 - Select Firstname from People where age = 25, Find all fields for people that are called smith and live in Portsmouth - Select * from People where lastname = "Smith" and Town = "Portsmouth", Find all fields for people that are called smith or live in Portsmouth - Select * from People where lastname = "Smith" or Town = "Portsmouth", Update - statement is used to modify the existing records in a table., Insert Into - statement is used to insert new records in a table., Delete - statement is used to delete existing records in a table.,

SQL Instructions

Yazdır
Yerleştir

Skor Tablosu

Görsel stil

Seçenekler

Şablonu değiştir

Otomatik olarak kaydedilen geri yüklensin mi: ?