Answer Posted / vijay

I have tried this query in my PC.Very simply I was able to
remove all duplicate rows.
Please try below query it will work out.

SELECT DISTINCT*FROM EMP(TableName);

You will get below table
EmpId Ename Sal DeptId
11 Ram 10000 10
22 Raj 20000 20
33 Anil 15000 30


Suppose if you have different ENAME but you want only
selected ENAME without duplicate records.
Where We can use below query.

SELECT DISTINCT*FROM EMP WHERE ENAME IN('RAM','RAJ','ANIL');

Please correct me if I am wrong.

How to add the custom code in Report?

129

---

Does table partitioning improve performance?

1015

---

What does ss stand for sexually?

1145

---

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1129

---

How does stuff differ from the replace function?

1064

---

List out the difference between union and union all in sql server?

1043

---

Why I am getting this error when dropping a database in ms sql server?

1120

---

What is the recovery model?

1061

---

Why normalization is used?

1069

---

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

1056

---

What are audit control procedures?

1034

---

Call by value and call by reference in procedure and function, with NOCOPY.

1351

---

How can you tell if a database object is invalid?

1118

---

What is the difference between functions and stored procedures?

1226

---

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

995

---