What is the Query to print out the individual total number of
duplicate row in sql.
Answers were Sorted based on User's Feedback
Answer / girija.112
ANS:
SELECT department_id,COUNT(department_id) AS "Occurrences"
FROM departments
GROUP BY department_id
HAVING ( COUNT(department_id) > 1 )
DEPARTMENT_ID Occurrences
------------- -----------
80 2
60 3
--In my 'departments' table , i have not assigned department_id column as a "primary key / unique key"
Is This Answer Correct ? | 28 Yes | 3 No |
Answer / raveendran
SQL>select * from a;
A B
---- -------------------------
1 Name
ABC
BCA
fdhgjdshfj
3 Name
ABC
BCA
fdhgjdshfj
2 Name
ABC
BCA
fdhgjdshfj
4 Name
ABC
BCA
fdhgjdshfj
5 asd
A B
---- -------------------------
asd
asd
asdd
6 asd
asd
7 asd asd
8 asd asd
sql>select count(b),b from a group by b having count(b)>=1;
T(B) B
---- -------------------------
4 Name
ABC
BCA
fdhgjdshfj
1 asd
asd
1 asd
asd
asd
asdd
2 asd asd
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / vivek ghorad
SELECT * FROM emp WHERE ROWID NOT IN(SELECT MIN(ROWID)FROM
emp GROUP BY empno,fname,dept);
Is This Answer Correct ? | 3 Yes | 6 No |
Answer / ashish bakal
select count(deptno), deptno from emp where rowid not in
(select min(rowid) from emp group by deptno) group by
deptno;
Is This Answer Correct ? | 0 Yes | 3 No |
How do I upgrade sql?
What is a sql schema used for?
which types of join is used in sql widely? : Sql dba
What are the different types of sql commands?
What is error ora-12154: tns:could not resolve the connect identifier specified?
What is pragma in sql?
What are the 3 types of behavioral triggers?
State the difference between implict and explict cursor's?
Which one is better subquery or joins?
how many tables will create when we create table, what are they? : Sql dba
Define select, insert, create, delete, update, drop keywords
Why plvtab is considered as the easiest way to access the pl/sql table?