MembersThe tblMembers table contains six fields. The LastName, FirstName, and MemberType fields contain text. The MemberID, JoinDate, and Fee fields contain numbers. The MemberType field contains one of the following letters: F for Family membership, A for one Adult membership, Y for one Youth membership, and S for one Senior membership.
Write a SQL SELECT statement that selects the MemberID, LastName, and FirstName fields for members having a last name that begins with the letter J.
What will be an ideal response?
SELECT MemberID, LastName, FirstName FROM tblMembers
WHERE LastName LIKE 'J%'
You might also like to view...
Which statement is true regarding the principles of an object-oriented language?
A. Persistence is not an optional object-oriented language requirement. B. Inheritance does not occur when a new class is derived from an existing class or base class. C. Encapsulation means hiding data in a class from other classes. D. Class variables should not be global so all elements of the program can see them.
Answer the following statements true (T) or false (F)
1. An array must be initialized when it is declared. 2. Subscript range errors are syntax errors. 3. Loop control variables may be used as array subscripts. 4. Single array elements may not be used as function arguments. 5. An array name with no subscript is a pointer.