Where do you specify them?

0 Answers  

---

I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

2 Answers   IBM,

---

If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 Answers  

---

how to take the back up of the DB2 table.

7 Answers  

---

what is check point and restart Logic ? why do we go for that ??

2 Answers   CGI, UST, Xansa,

---

what is difference between Plan and Package

1 Answers   Syntel,

---

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 ?

0 Answers   JPMorgan Chase,

---

cursor with hold explain ?

1 Answers   Verizon,

---

What is universal database?

0 Answers  

---

what is the use of cursors?

3 Answers   iGate,

---

What is the information associated with sysibm.syslinks table?

0 Answers  

---

What is -904 sql code? How to resolve it?

3 Answers  

---