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
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?
What is normalization? Explain different levels of normalization?
What is the maximum length of an extended property?
In which table collections errors are stored.
How to use timestamp datatypes
Explain about post-relational databases?
How is data stored in dbms?
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.
Who are end users in dbms?
How you can make a parameterized view?
What is the physical representation for a many-to-many relationship?
How to read and create .LDC data files which are used by linguatic dictionary.
How would you design a database for an online site, which would average a million hits a day?
Explain about the database management systems.
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