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.
- 4 Answers
- 5825 Views
- I also Faced
- E-Mail Answers
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
What protocol does sql server use?
What is the purpose of forms?
Mention what are the different types of ssrs reports?
What is the name of reporting services config file and what’s it’s used for?
What are the triggers in sql?
What is the difference between dataadapter and datareader?
Differentiate between truncate vs delete in mssql?
What is page in sql server?
Name the different type of indexes in sql?
How you can get the list of largest tables in a database?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What is sql server query analyzer?
What happens if strings are casted into wrong code pages in ms sql server?
What is Service Broker in sql server 2012?
What is set nocount on and what is set nocount off?
