SQL Select Query For Specific Records
Given a table named Employees with a field named Last Name, which of the following SQL statements selects all records with the last name 'Jones'?
A
FROM Employees SELECT * WHERE Last Name = 'Jones'
B
FROM Employees SELECT all WHERE [Last Name] = 'Jones'
C
SELECT * FROM Employees WHERE [Last Name] = 'Jones'
D
SELECT * FROM Employees WHERE [Last Name] <> 'Jones'
Question Leaderboard
Not enough data yet to show leaderboard.