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
Explain features of analysis services?
last function used in MS Access to convert sql what function will use in sql
What stored procedure can you use to display the current processes?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
what is an index? : Sql server database administration
Give a example to search fr a string in all stored procedure in sql server.
How to test odbc dsn connection settings?
What is row_number function?
What are differences in between sql server 2012 and sql server 2016?
What is 4nf in normalization form?
What is the difference between varchar and varchar(max) datatypes?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
What is the parse query button used for?
What are user defined functions in ms sql server?
How to create user defined functions with parameters?