how will I find the duplicate rows count from employees
tablein oracle.
Answer Posted / avik ganguly
select * from emp a where rowid = (select max(rowid) from
emp where empno = a.empno group by empno having count(*) >1)
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
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
Explain about the database management systems.
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?
Explain about the storage and physical database design?
What is dbms and its application?
I have a few records all are same structures data, I want to store data in multiple targets how
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
State the acid rules?
How to read and create .LDC data files which are used by linguatic dictionary.
What are the 18 schemas?
How would you design a database for an online site, which would average a million hits a day?
In which table collections errors are stored.
What is database design and development?
Explain the cube operator?