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)

Explain about xml databases?

0 Answers  

---

I have a few records all are same structures data, I want to store data in multiple targets how

0 Answers   CTR, Infosys, Polaris,

---

Can you have a nested transaction?

1 Answers  

---

what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me

1 Answers   IBM,

---

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

0 Answers   Covansys,

---

What are the disadvantages of cursors? How can you avoid cursors?

2 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  

---

How to customize error conditions.

0 Answers  

---

How long can an error message be in raiseerror function?

0 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

0 Answers  

---

What are the three types of database design?

0 Answers  

---

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

2 Answers  

---