Answer / s

Select * from emp
where SUBSTR(empname,4,2) = 'EN'

4 is the starting position and returns 2 characters after
that.

What is the database descriptor?

2 Answers  

---

explain about index with examples

2 Answers   Syntel,

---

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---

What is UNION,UNION ALL?

2 Answers  

---

What is rebind in db2?

0 Answers  

---

What is ALTER ?

3 Answers  

---

What is sqlca?

0 Answers  

---

What do you mean by commit and rollback?

0 Answers  

---

What are the various locking levels available?

3 Answers  

---

How do I import data from excel to db2?

0 Answers  

---

What is a trigger in the db2 database?

0 Answers  

---

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---