select name,year from ship where name like '% %';

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 / challa yerriswamy

Answer Posted / challa yerriswamy

select name,year
from ship
where name like '% %';

Is This Answer Correct ?

10 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is an index in sql?

745

How optimize sql query with multiple joins in sql server?

606

What are subqueries in sql server?

808

What is the maximum size of column in sql server?

680

What happens if null values are involved in boolean operations?

752

Explain isolation levels that sql server supports?

776

What is a partitioned view?

778

What is executereader?

741

What is failover clustering overview?

786

How do you delete a trigger?

752

How to provide column names in insert statements in ms sql server?

825

Explain how dts is used to extract, transform and consolidate data?

772

List out what other servers you can use with ssrs?

115

What is a db view?

701

How many columns can we include on clustered index ?

689