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,

---

What is difference between standardization and normalization?

0 Answers  

---

How can we write or define DDL statements in Sql server and DML statements?

3 Answers  

---

what protocol both networks use? : Sql server database administration

0 Answers  

---

Explain cross join or cartesian product in sql?

0 Answers  

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

0 Answers  

---

What are the types of database recovery models?

0 Answers   HCL,

---

Explain important index characteristics?

0 Answers  

---

What is the full meaning of dml?

0 Answers  

---

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

1 Answers   HP,

---

Differences between functions and stored procedures?

8 Answers   247Customer, Accenture,

---

1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

12 Answers   Accenture,

---