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

Explain features of analysis services?

1079

last function used in MS Access to convert sql what function will use in sql

2114

What stored procedure can you use to display the current processes?

944

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1078

what is an index? : Sql server database administration

1026

Give a example to search fr a string in all stored procedure in sql server.

1063

How to test odbc dsn connection settings?

1086

What is row_number function?

1058

What are differences in between sql server 2012 and sql server 2016?

1097

What is 4nf in normalization form?

1062

What is the difference between varchar and varchar(max) datatypes?

1134

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1059

What is the parse query button used for?

1088

What are user defined functions in ms sql server?

1064

How to create user defined functions with parameters?

1298