Which sql statement is used to return only different values?

0 Answers  

---

How do we use distinct statement? What is its use?

0 Answers  

---

What is rtm in testing?

0 Answers  

---

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.

2 Answers   Maruti Suzuki,

---

.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 Answers  

---

Can triggers stop a dml statement from executing on a table?

0 Answers  

---

wht is the difference between sqlaserver2000 and 2005

1 Answers   ABC, IBM,

---

Explain two easy sql optimizations.

0 Answers  

---

What is RAC in oracle?

7 Answers   MCN Solutions,

---

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?

7 Answers   Cognizant,

---

What are stored procedures used for?

0 Answers  

---

What are the different types of joins and explain them briefly.

3 Answers  

---