Interested to Buy Any Domain ? << Click Here >> for more details...
What keyword does an SQL SELECT statement use for a string
search?
- 2 Answers
- 8155 Views
- I also Faced
- E-Mail Answers
Answer Posted / kirtish srivastava
Like is used with where clause to search,update, and delete a record using wild cards.
Example:-
To Search;-
select * from Employee where Name like 'a%'
Note;- Search all records whose employee name is stared from a character.
To Update:-
update Employee set Name='amit' where Name like 'a%'
update all records with name amit whose employee name is started from a character.
To Delete:-
delete from Employee where Name like 'a%'
Delete all records whose employee name is started from a Character.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to create backup table in db2?
How is a typical db2 batch pgm executed?
How to compare data between two tables in db2?
What is the clustering index in the db2 database?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What are db2 tables?
What is runstats db2?
What is sqlca?
Explain about open switch business continuity software?
What are bind parameters in db2?
How do I change the column size in db2?
What are iseries servers?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What are union and union all?
What is isolation level in db2?
