Interested to Buy Any Domain ? << Click Here >> for more details...
how will I find the duplicate rows count from employees
tablein oracle.
- 2 Answers
- 5676 Views
- I also Faced
- E-Mail Answers
Answer Posted / manoj
select employee_id, count(*) from employees group by
employee_id having count(*) > 1
| Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
What is the database development process?
Explain about relational operator join?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
Explain about the relational database?
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?
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?
How long can an error message be in raiseerror function?
How to use online Backups?
How you can make a parameterized view?
Explain the cube operator?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
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
Explain about the storage and physical database design?
What are data modelling techniques?
What are the three basic rules which are to be followed for the relational model of the database?
