Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 Answers  

---

How to get the ddl of a table in db2?

0 Answers  

---

What is blu acceleration in db2?

0 Answers  

---

How do I add a column in db2?

0 Answers  

---

Explain about mirror activator disk mirroring?

0 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,

---

Do we need cursor for Count(*)?

4 Answers   iGate,

---

Explain the use of the WHERE clause?

1 Answers  

---

what are the SQL codes u freequently got?

2 Answers   Logica CMG,

---

How to check last update on table in db2?

0 Answers  

---

How to connect to db2 database from windows command line?

0 Answers  

---

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

0 Answers   IBM,

---