Answer Posted / smitha

;with empctc(empid,ename,sal,deptid,ranking)
as
(Select empid,ename,sal,deptid,ranking=Dense_rank() over (
partition by empid,ename,sal,deptid order by NEWID() asc)
from emp
)
delete * from empctc where ranking>1

Name 3 ways to get an accurate count of the number of records in a table?

1086

---

What is indexing and its types?

1056

---

how many bits ip address consist of? : Sql server database administration

943

---

Explain different types of index?

1101

---

How to define and use table alias names in ms sql server?

1208

---

What are sub reports and how to create them?

144

---

What is spid in sql server profiler?

1168

---

how to overcome kernel isssues

1687

---

difference between Clustered index and non clustered index ?

1035

---

How to configure odbc dsn with different port numbers?

1152

---

What happens if date-only values are provided as date and time literals?

1077

---

What are the operating modes in which database mirroring runs?

1137

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

7008

---

What is the difference between ‘having’ clause and a ‘where’ clause?

1086

---

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1021

---