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 / dhiraj
select Name
from ship
where name in ('Saint Louis','Jet Lake')
| Is This Answer Correct ? | 1 Yes | 10 No |
Post New Answer View All Answers
How can you list all the table constraints in a database?
What is wrong with sql server client libarary dll, ntwdblib.dll?
What is transactional replication?
Explain how you can configure a running aggregate in SSRS?
How to create an inline table-valued function?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
When I delete any data from a table, does the sql server reduce the size of that table?
What is data source document?
What is the difference between the 2 operating modes of database mirroring?
What are wait types?
How to convert numeric values to integers in ms sql server?
How to download and install microsoft sql server management studio express?
What is the process of indexing?
how to control the amount of free space in your index pages? : Sql server database administration
How to identify current user in ssrs report?