Interested to Buy Any Domain ? << Click Here >> for more details...
What keyword does an SQL SELECT statement use for a string
search?
- 2 Answers
- 8204 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
What is the function of logging in the db2 database?
How to connect to db2 database from windows command line?
What are the full forms of spufi and dclgen and why are they used?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is ibm db2 used for?
How can we retrieve the total number of records in RPG & CLLE?
What is the usage of open cursor command?
What is db2 command?
How many types of page locks can be held in db2?
How do I change the column size in db2?
What is the maximum size of a char data type in db2?
What is check constraint. Explain with example.
How to check last update on table in db2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
