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.

Answers were Sorted based on User's Feedback



If suppose in a table ship(name,year),find ship name having first and last name(i.e having space i..

Answer / challa yerriswamy

select name,year
from ship
where name like '% %';

Is This Answer Correct ?    10 Yes 1 No

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space i..

Answer / sandeep modapathi

select name from ship where where PATINDEX ('% %',name )>0

Is This Answer Correct ?    1 Yes 2 No

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space i..

Answer / suresh

select name,year
from ship
where name like '%,%';

Is This Answer Correct ?    1 Yes 8 No

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space i..

Answer / dhiraj

select Name
from ship
where name in ('Saint Louis','Jet Lake')

Is This Answer Correct ?    1 Yes 10 No

Post New Answer

More SQL Server Interview Questions

Tell me the phases a transaction has to undergo?

0 Answers  


Can you insert NULL in unique column?

0 Answers   MCN Solutions,


How you can change a cross join into an inner join?

0 Answers  


Explain rdbms?

0 Answers  


what's the difference between delete table and truncate table commands? : Sql server database administration

0 Answers  






Explain the benefits of user-defined functions?

0 Answers  


Hi..here i would like to know the Backup and Restore models?

2 Answers   HCL,


how to dispaly a particular row details from a given table

2 Answers  


can you any body tell me why are go for the rebuild the master database.what is the reason?

2 Answers  


I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

0 Answers  


If a stored procedure is taking a table data type, how it looks?

1 Answers  


i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

3 Answers   iFlex,


Categories