Answer / manoj

select employee_id, count(*) from employees group by
employee_id having count(*) > 1

Answer / avik ganguly

select * from emp a where rowid = (select max(rowid) from
emp where empno = a.empno group by empno having count(*) >1)

What is the physical representation for a many-to-many relationship?

0 Answers  

---

How to combine two function together?

0 Answers  

---

what is Normalization?

6 Answers   TCS,

---

explain detail about ftp in datastage?

0 Answers   IBM,

---

What is normalization? Explain different levels of normalization?

8 Answers   CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,

---

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

0 Answers  

---

How can you fix a poorly performing query?

0 Answers  

---

Can you instantiate a COM object by using T-SQL?

1 Answers  

---

Write short notes on XSU and JAVA

1 Answers  

---

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

0 Answers  

---

Explain the family trees and connection by clause.

1 Answers  

---

how will I find the duplicate rows count from employees tablein oracle.

2 Answers  

---