employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

What stored by the tempdb ? : sql server database administration

0 Answers  

---

What is the difference between for xml raw and for xml auto?

0 Answers  

---

How to create a new table in a given schema?

0 Answers  

---

Difference between DELETE and TRUNCATE?

0 Answers   TCS,

---

What does executeupdate return?

0 Answers  

---

Can you explain the disadvantages/limitation of the cursor?

0 Answers  

---

Determine when an index is appropriate?

0 Answers  

---

What are key constraints?

0 Answers  

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  

---

What is acid db?

0 Answers  

---