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
Answer / challa yerriswamy
select name,year
from ship
where name like '% %';
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / sandeep modapathi
select name from ship where where PATINDEX ('% %',name )>0
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / suresh
select name,year
from ship
where name like '%,%';
Is This Answer Correct ? | 1 Yes | 8 No |
Answer / dhiraj
select Name
from ship
where name in ('Saint Louis','Jet Lake')
Is This Answer Correct ? | 1 Yes | 10 No |
Tell me the phases a transaction has to undergo?
Can you insert NULL in unique column?
How you can change a cross join into an inner join?
Explain rdbms?
what's the difference between delete table and truncate table commands? : Sql server database administration
Explain the benefits of user-defined functions?
Hi..here i would like to know the Backup and Restore models?
how to dispaly a particular row details from a given table
can you any body tell me why are go for the rebuild the master database.what is the reason?
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
If a stored procedure is taking a table data type, how it looks?
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.