select Name from ship where name in ('Saint Louis','Jet La

If suppose in a table ship(name,year),find ship name having
first and last name(i.e having space in between)
ex: SAINT LOUIS,JET LAKE.

Question Posted / dhiraj

Answer Posted / dhiraj

select Name
from ship
where name in ('Saint Louis','Jet Lake')

Is This Answer Correct ?

1 Yes

10 No

Please Help Members By Posting Answers For Below Questions

How to access the inserted record of an event?

994

What are the 10 characteristics of data quality?

903

How much space does sql server 2016 take?

912

If a stored procedure is taking a table data type, how it looks?

6356

Where the sql logs gets stored? : sql server database administration

918

What are the purpose of Normalisation?

1003

What is the use of tempdb? What values does it hold?

1003

Explain few of the new features of sql server 2008 management studio

864

How to see existing views in ms sql server?

989

What are translations and its use? : sql server analysis services, ssas

995

What is raid and what are different types of raid levels?

1085

What is instead of trigger sql server?

936

How do I find my localdb version?

941

What is table constraint?

932

How to create a testing table with test data in ms sql server?

1017