How reterive duplicate value in SQL?
Answers were Sorted based on User's Feedback
Answer / justus
create table emp
empid empname
----- --------
101 a
102 b
103 a
104 c
105 a
select empname from emp group by empname having count(empname)>1
Is This Answer Correct ? | 12 Yes | 2 No |
Answer / sivasiva
create table emp
empid empname
----- --------
101 a
102 b
103 a
104 c
105 a
select empid from emp groupby empid,empname having count>1
Is This Answer Correct ? | 17 Yes | 12 No |
Answer / satishkulala
select empname from emp group by empname having count(empname)>1
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / rajesh.a
select count(*),empname from emp group by empname having count(*)>1
Is This Answer Correct ? | 4 Yes | 0 No |
create table emp (empid int,empname varchar)
insert into emp values (101,'a')
insert into emp values (102,'b')
insert into emp values (103,'a')
insert into emp values (104,'c')
insert into emp values (105,'a')
select * from emp
SELECT EmpName,Count(EmpID)Cnt From Emp Group By EmpName
Having Count(EmpName) > 1
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ashish jain
create table emp
empid empname
----- --------
101 a
102 b
103 a
104 c
105 a
select empname from emp where count(empname)>1
Is This Answer Correct ? | 6 Yes | 10 No |
Can anybody explain me cold backup and hot backup?
What do you mean by collation recursive stored procedure?
What does Master database contains?
What stored by the msdb?
Can some one please help with a query which will take only max value of a column in a join.
what are batch in sql server?
Tell me what is difference between view and materialized view?
Is truncate a dml command?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
What is split brain scenario in DB mirroring?
What are the basic features of a trigger in ms sql server?
How to execute a stored procedure in ms sql server?