Mention a credible reason why select* is never given preference in an sql program that has been embedded.

0 Answers  

---

can any one expalin check point with an example?

1 Answers  

---

Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,

---

Is db2 relational database?

0 Answers  

---

What keyword does an SQL SELECT statement use for a string search?

2 Answers  

---

---

What is a cursor in programming?

0 Answers  

---

What is COPY PENDING status?

6 Answers  

---

my project is insurance management system,how to explain my work environment in interview?

2 Answers   CGI, Value Labs,

---

Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

3 Answers   IBM,

---

How to find the number of rows in a db2 table?

0 Answers  

---

what types of copies can be made with the COPY Utility ?

1 Answers  

---

db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2

9 Answers   TCS,

---