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
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
Explain about relational database management systems?
Who are naive users?
Why does this query return 0?
What is normalization? Explain different levels of normalization?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
What is dbms explain in brief?
What is an application role and explain a scenario when you would use one?
Explain about the relational database?
What is a database development?
How to customize error conditions.
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
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 normal forms?
Explain about relational operator join?