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 |
What is the difference between unique and primary key constraints?
What is the difference between alter trigger and drop trigger statements?
What are the events on which a database trigger can be based?
how to return query output in html format? : Sql dba
i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?
What is auto increment feature in sql?
What is offset and limit in sql?
Explain the types of joins in sql?
What operating systems are supported by oracle sql developer?
How does one use sql*loader to load images, sound clips and documents? : aql loader
How to add new employee details in an employee_details table with the following details
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????