【单选题】In the relation of tblMember (Member_Id, Title, Surname, Fname, Street_Address, Suburb, City, Phone, Email) ,Which SQL Command can find the members who live in Berkeley but who do not live on 123 Mai...
A.
select Member_Id,Surname,FName,Street_Address,City from tblMember where City= 'Berkeley' and Street_Address!= '123 Main St.' order by Surname desc;
B.
select Member_Id,Surname,FName,Street_Address,City from tblMember where City= 'Berkeley' and Street_Address!= '123 Main St.' order by Surname;
C.
select * from tblMember where City= Berkeley and Street_Address!= '123 Main St.' order by Surname;
D.
select Member_Id,Surname,FName,Street_Address,City from tblMember where City= Berkeley and Street_Address!= '123 Main St.' order by Surname;
【单选题】In the relation of tblMember (Member_Id, Title, Surname, Fname, Street_Address, Suburb, City, Phone, Email) ,Which SQL Command can find the members who live in Oakland, show Member Id, Surname, First...
A.
select * from tblMember where City= 'Oakland' order by Surname;
B.
select Member_Id,Surname,FName,Street_Address,City from tblMember where City=” Oakland ” order by Surname desc;
C.
select Member_Id,Surname,FName,Street_Address,City from tblMember where City= 'Oakland' order by S urname;
D.
select * from tblMember where City = 'Oakland' order by Surname asc ;