I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

---

Define inner join in sql server joins?

0 Answers  

---

What are the properties and different types of sub-queries?

0 Answers  

---

What are clustered and non-clustered index?

0 Answers  

---

How do you identify a foreign key?

0 Answers  

---

---

How to provide Security for package?

1 Answers   Convergys,

---

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

2 Answers   Accenture, Merrill Lynch, Wipro,

---

What do you mean by 'normalization'?

0 Answers   Ernst Young, Thomson Reuters,

---

Mention the differences between sql server and mysql.

0 Answers  

---

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

0 Answers  

---

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

0 Answers   HCL,

---

What does it mean to manipulate data?

0 Answers  

---