how will I find the duplicate rows count from employees
tablein oracle.
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
How to customize error conditions.
Explain about a primary key?
In which table collections errors are stored.
Write short notes on manual refreshes.
How to read and create .LDC data files which are used by linguatic dictionary.
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
Explain about relational database management systems?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
What are the 18 schemas?
How to replace not in with not exist?
What is dbms explain in brief?
Why does this query return 0?
What are the types of database model?
What is dbms and its application?
What is the maximum length of an extended property?