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 different types of table joins?

960

What are the different kinds of ssrs reports?

206

How to get a list of columns in a view using the "sp_columns" stored procedure?

984

What is user-defined inline table-valued function?

896

What is dimension table? : sql server analysis services, ssas

968

How to create a new schema in a database?

1072

Can coalesce return null?

945

What are click through reports?

138

Tell me what is a linked server?

986

What are audit control procedures?

939

How can I get data from a database on another server?

932

Can we add a cpu to sql server?

954

How many clustered indexes there can be on table ?

985

How can you list all the table constraints in a database?

880

Explain different types of self contained sub query?

948