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.
Answer Posted / challa yerriswamy
select name,year
from ship
where name like '% %';
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What are the limitations/drawbacks or ssrs 2008 r2?
Equi join and non equi join is possible with sql server?
What are different types of replication in sql server?
What is the process of normalization?
How will you go about resolving deadlocks?
How many servers can we create in a single subscription?
How do you test your database? : sql server database administration
What are the advantages of partitioning?
What is the difference between count () and rowcount ()?
What is default constraint in ms sql server?
Explain tables in SQL Azure?
What are the new scripting capabilities of ssms? : sql server management studio
What is TDS(Tabular Data Stream) Gateway?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
what is a schema in sql server 2005? : Sql server database administration