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
What is the syntax for encrypting a column in SQL Server?
What is the difference between having clause and where clause in sql server?
what are the Prerequisites for Replication?
how will add additional conditions in sql?
What functions can a view be used to performed?
How to populate a table in sql server?
What is application role in sql server database security? : sql server security
What is the most common type of join?
What are different backups available in sql server?
What is the osql utility?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
How to create dbo table in sql server?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
What are the types of sql server?
How to find out what is the default collation in a database?