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,

---

Explain differentiate between a having clause and a where clause?

0 Answers  

---

What are the steps to process a single select statement?

0 Answers  

---

What is table constraint?

0 Answers  

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---

---

Can you link only other SQL Servers or any database servers such as Oracle?

1 Answers  

---

can any one please send sql quries most used in applications.

2 Answers  

---

what are batch in sql server?

2 Answers   Satyam,

---

what is blocking? : Sql server database administration

0 Answers  

---

Explain the purpose of indexes?

0 Answers  

---

from the table display the 2nd highest salary? and also the least 2nd salay?

8 Answers  

---

How sql server executes a statement with nested subqueries?

0 Answers  

---