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 |
Explain what are commit and rollback in sql?
Can I remove the default constraint columns in SQL SERVER?
How to link up the text file to a Database table?
What is the difference between grant and with grant while giving permissions to the user?
How to run sql server 2005 books online on your local system?
Do you know the isolation level that sql server support?
What are distributed partitioned views?
Can foreign key be duplicate?
can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3
How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.
How to get the definition of a user defined function back?
What is global temp table?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)