Find all fields for people called FRED - SELECT * FROM People WHERE firstname = "FRED", Column - Collection of data values of the same type, Record/row - Collection of information about someone or something, Find first name of people with an age above 25 - SELECT Firstname FROM People WHERE age > 25, Find first name 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", Find all fields for people whose first name begins with C - SELECT * FROM People WHERE Firstname LIKE 'C%',

SQL Match up quiz

인쇄
퍼가기

순위표

비주얼 스타일

옵션

템플릿 전환하기

자동 저장된 게임을 복구할까요?