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 / suresh

Answer Posted / suresh

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

Is This Answer Correct ?

1 Yes

8 No

Please Help Members By Posting Answers For Below Questions

Write a program using SQL queries to find a unique entry in a table.

943

How to turn on the mssql api module in php?

1017

What is normalization? Explain its different types?

1039

how many no of arguments can be passed in procedures and functions

5466

In what version of sql server were synonyms released?

908

What is dml command?

889

Write a program to fetch first 10 records from a file?

971

What command do we use to rename a db, a table and a column?

876

What are exact numeric data types in ms sql server?

994

Differentiate between a having clause and a where clause.

928

What are data files?

984

Explain how does the report manager work in ssrs?

903

Explain the advantages of merge replication?

896

What is compound operators?

978

what is a transaction and what are acid properties? : Sql server database administration

966