Please enter the SQLstatement to choose all of the records from - ProProfs
     

Please enter the SQL statement to choose all of the records from a table named owners where the value of the column lastname begins with an s.



A. Select * from owners where lastname= s

This question is part of Network Engineer Candidate Technical Assessment

+ AnswerRequest Answer
...

3 Answers

timhosack

Timhosack

Answered on Mar 02, 2017

Incorrect.

select from owners

where lastname like 's%'

John Adney

John Adney

Answered on Mar 02, 2017

That answer would only result in zero records because no records would just be "s".

The correct syntax for all names beginning with "s" is

select from owners

where lastname like 's%'

John Smith

John Smith

Answered on Dec 01, 2016

Select from owners where lastname= s

John Adney

John Adney

No. close but no.

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.