Answer Posted / vijay

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

List out the differences between the clustered index and non-clustered index in sql server?

960

---

Explain how you can deploy an SSRS report?

141

---

Explain unique key in sql server?

981

---

Is the log file is a part of file group?

993

---

What is difference between stored procedure and user defined function?

1057

---

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

992

---

How can you append an identity column to a temporary table?

901

---

How to Insert multiple rows with a single insert statement?

1025

---

What are the five major components of a dbms?

901

---

Define union, union all, minus, intersect?

946

---

How to return the date part only from a sql server datetime datatype?

1053

---

What is tablesample?

1057

---

Which trace flags are enabled in sql server?

962

---

What is rank function?

997

---

What is 2nf normalization?

980

---