Answer Posted / gangi naidu.k

select * from emp where emp=(select sal from emp group by
sal having count(sal)>1)

Explain the functionalities that views support?

1098

---

In which files does sql server actually store data?

882

---

what is a sub-report?

140

---

What do you mean by sql server agent?

974

---

How many databases instances are there in sql server 2000?

1077

---

How optimize sql query with multiple joins in sql server?

875

---

Why it is recommended to avoid referencing a floating point column in the where clause?

949

---

Explain alternate key, candidate key and composite key in sql server?

895

---

when you create a database how is it stored? : Sql server database administration

997

---

what do you understand by change data capture?

978

---

Explain about temporary stored procedure?

993

---

Does order by actually change the order of the data in the tables or does it just change the output?

1120

---

What is pivot and unpivot?

997

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1038

---

What are the differences between triggers and stored procedures?

1038

---