What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

what are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

---

Differentiate between sql temp table vs table variable?

0 Answers  

---

What is a job?

3 Answers  

---

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

---

How to insert new line characters into strings?

0 Answers  

---

What is difference statement and preparedstatement?

0 Answers  

---

How is a full-text index updated?

0 Answers  

---

What are different types of statement?

0 Answers  

---

What is Covering Indexes? Plz explain with example

3 Answers  

---

diffrence between Cluster Index and non Cluster Index

3 Answers   Wipro,

---

How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,

---