Multiple choices 8/50
(Choose 1 answer)
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?
A. SELECT * FROM Persons WHERE FirstName='a'
B. SELECT * FROM Persons WHERE FirstName LIKE '%a'
C. SELECT * FROM Persons WHERE FirstName='%a%'
D. SELECT * FROM Persons WHERE FirstName LIKE '%'
Next
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16 17
18 19 20 21
22
23
24
25 26
27 28
29
30
31
32
33
34
35 36
37
38
39
43
44
45 46 47 48
49 50
40 41 47
