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

What are various aggregate functions that are available?

990

what is an index? : Sql server database administration

987

What is the importance of concurrency control?

1231

How to find out what is the default collation in a database?

1126

Explain insert into select statement?

963

What is TDS(Tabular Data Stream) Gateway?

121

Data table as parameter in sql server?

1051

What gets stored inside msdb database?

1255

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1061

What are the advantages of the mirroring?

1095

How to create a new schema in a database?

1154

How does a profiler work?

937

What is explicit cursors?

1080

What is the beast way to write CTE in SQL Server ?

1052

Explain atomicity?

1063