how will I find the duplicate rows count from employees
tablein oracle.
- 2 Answers
- 5039 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 database design and development?
Write the fastest query to find out how many rows exist in a table?
How to read and create .LDC data files which are used by linguatic dictionary.
Who are end users in dbms?
Explain about query and reporting.
What are the constraints on severity level in raiseerror?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
Which data type cannot be used as a parameter in a udf?
What are the 18 schemas?
How to generate OIDS
How would you design a database for an online site, which would average a million hits a day?
What are data modelling techniques?
fact table and dimension table containg one to many relationship or many to one relastionship
What are the main phases of database development?
What is the database development process?
