Answer / sunil1405

SELECT FNAME WHERE FNAME LIKE 'S%';

Answer / 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.

What is an inner join, and an outer join ?

1 Answers   CTA,

---

what is different three logs in DB2?

1 Answers   Syntel,

---

why we create view.

5 Answers  

---

how can u understand the end of the table ?

1 Answers   TCS,

---

Describe what a storage group(STOGROUP) is?

2 Answers  

---

Usually, which is more important for DB2 system performance - CPU processing or I/O access?

1 Answers  

---

How is the SUBSTR keyword used in sql?

1 Answers  

---

Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers  

---

What is db2 catalog database?

0 Answers  

---

how we will do null data selection in cobol-db2 program

2 Answers   Wipro,

---

what is difference between Static call and Dynamic call? How does it function?

1 Answers   Syntel,

---

What does db2 stand for?

0 Answers  

---