select employee_id, count(*) from employees group by employee

how will I find the duplicate rows count from employees
tablein oracle.

Question Posted / manoj

Answer Posted / manoj

select employee_id, count(*) from employees group by
employee_id having count(*) > 1

Is This Answer Correct ?

18 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the three types of database design?

1080

What is dbms and its application?

1051

What is normalization? Explain different levels of normalization?

63395

What is the maximum length of an extended property?

1034

fact table and dimension table containg one to many relationship or many to one relastionship

2546

Who are end users in dbms?

1033

Explain about query and reporting.

2133

What are the 18 schemas?

1185

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?

2468

What are the key features of dbms?

1041

What is a database development?

1014

How can I detect whether a given connection is blocked?

1117

Explain about relational database management systems?

1012

Explain about the storage and physical database design?

968

Explain about network model?

1047