How to get only duplicated records

Question

want duplicated record

Answer 1

only duplicated or without duplicated??

Answer 2

select distinct sal from faculty not in( select sal from faculty);

Answer 3

ok try this..
i think somerhing gets wrong in my query

Answer 4

distinct gives you without duplicates
suppose you have 4 rows which select by customer name,now if there are 2 duplicates then your query count no of without duplicates and give without duplicates rows

Answer 5

CREATE TABLE EMPLOYEE
(
id INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
EMPNAME VARCHAR(100),
SALARY DECIMAL
)

SELECT * FROM EMPLOYEE

INSERT INTO EMPLOYEE VALUES ( ‘Pawan’ , 100000 )
INSERT INTO EMPLOYEE VALUES ( ‘Pawan’ , 80000 )
INSERT INTO EMPLOYEE VALUES ( ‘Pawan’ , 40000 )
INSERT INTO EMPLOYEE VALUES ( ‘Rahul’ , 100000 )
INSERT INTO EMPLOYEE VALUES ( ‘Pawan’ , 100000 )
INSERT INTO EMPLOYEE VALUES ( ‘Gauri’ , 100000 )
INSERT INTO EMPLOYEE VALUES ( ‘Gauri’ , 100000 )
INSERT INTO EMPLOYEE VALUES ( ‘Rahul’ , 100000 )
INSERT INTO EMPLOYEE VALUES ( ‘Deepa’ , 100000 )

–Query to delete duplicate names in the above table
SELECT
name, salary, COUNT(*)
FROM
EMPLOYEE
GROUP BY
name, salary
HAVING
COUNT(*) > 1

Answer 6

yes this query work thanks @Akwin

Answer 7

only duplicated

Answer 8

select customer_name, count(distinct(customer_name))
where count(distinct(customer_name))>1;

Answer 9

only duplicated. . I think above query works, once excute and let me know. coz iam on mobile

Answer 10

CREATE TABLE EMPLOYEE
(
id INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
EMPNAME VARCHAR(100),
SALARY DECIMAL
)

SELECT * FROM EMPLOYEE

INSERT INTO EMPLOYEE VALUES ( ‘Pawan’ , 100000 )
INSERT INTO EMPLOYEE VALUES ( ‘Pawan’ , 80000 )
INSERT INTO EMPLOYEE VALUES ( ‘Pawan’ , 40000 )
INSERT INTO EMPLOYEE VALUES ( ‘Rahul’ , 100000 )
INSERT INTO EMPLOYEE VALUES ( ‘Pawan’ , 100000 )
INSERT INTO EMPLOYEE VALUES ( ‘Gauri’ , 100000 )
INSERT INTO EMPLOYEE VALUES ( ‘Gauri’ , 100000 )
INSERT INTO EMPLOYEE VALUES ( ‘Rahul’ , 100000 )
INSERT INTO EMPLOYEE VALUES ( ‘Deepa’ , 100000 )

–Query to find out the rows with duplicate names in the above table

–Ouery will give u the name
SELECT EmpName FROM EMPLOYEE GROUP BY EmpName HAVING COUNT(EmpName) > 1

–Query if you all the details
SELECT id , EmpName , Salary FROM Employee WHERE EmpName IN
(SELECT EmpName FROM EMPLOYEE GROUP BY EmpName HAVING COUNT(EmpName) > 1)

Try this too...