How do you select all the records from a table named "EMP" where the - ProProfs Discuss

Ask a Question + Ask Question

Advertisement

Speak now

Ask a Question + Ask Question

How do you select all the records from a table named "EMP" where the value of the column "Last_Name" is "KING"?

Asked by Maarsh, Last updated: Apr 09, 2024

+ Answer

Request

0
Follow

Share

Answer Anonymously
Answer Later

Copy Link

5 Answers

Answered Apr 22, 2017

SELECT * FROM EMP WHERE LAST_NAME = 'KING';
it's correct as well...

1

Share

Answered Jul 23, 2017

When the like keyword is used the % sign should be used

select * from emp where last name = 'KING' is the correct answer

Share

Answered Jul 15, 2017

SELECT * FROM EMP WHERE Last_Name = 'KING';

It is correct answer.

Share

HmAzam

Answered Jul 15, 2017

SELECT * FROM EMP WHERE Last_Name = 'KING';

It is correct answer.

Share

John Smith

Answered Oct 25, 2016

SELECT * FROM EMP WHERE Last_Name LIKE KING

Share

Write Your Answer

More Pl SQL Questions

Ask Your Own Question

Advertisement

Advertisement

Search
Image library
Upload

All Google Images

Commercial use license images

Search for Google images Google Image Icon

Google Image Icon

Select a recommended image

Upload from your computer

Image Preview

Search
Image library
Upload

All Google Images

Commercial use license images

Search for Google images Google Image Icon

Google Image Icon

Select a recommended image

Upload from your computer

Image Preview

Search
Image library
Upload

All Google Images

Commercial use license images

Search for Google images Google Image Icon

Google Image Icon

Select a recommended image

Upload from your computer