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 user-defined functions? What are the types of user-defined functions that can be created?

981

What is the language structure to add a record to a table?

967

What the difference between UNION and UNIONALL?

989

Can I save my report as html, excel or word? : sql server management studio

908

What is data source document?

980

What is the main difference between ‘between’ and ‘in’ condition operators?

1106

What are different types of subquery?

1182

Can two tables have the same primary key?

1136

Can you create a logon trigger in sql server 2005 express edition?

1032

What is a benefit of using an after insert trigger over using a before insert trigger?

931

What are the different types of locks in the database?

875

Mention the differences between local and global temporary tables.

955

how can u get last observation in an unknown dataset ?

2388

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

957

What is partition, how will you implement it? : sql server analysis services, ssas

994