Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How reterive duplicate value in SQL?

Answers were Sorted based on User's Feedback



How reterive duplicate value in SQL?..

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

How reterive duplicate value in SQL?..

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

How reterive duplicate value in SQL?..

Answer / satishkulala

select empname from emp group by empname having count(empname)>1

Is This Answer Correct ?    5 Yes 0 No

How reterive duplicate value in SQL?..

Answer / rajesh.a

select count(*),empname from emp group by empname having count(*)>1

Is This Answer Correct ?    4 Yes 0 No

How reterive duplicate value in SQL?..

Answer / jaleel ahamed s

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

How reterive duplicate value in SQL?..

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

Post New Answer

More SQL Server Interview Questions

What are the transaction properties?

0 Answers  


Differencr Between DELETE and TRUNCATE?

3 Answers   ADP,


What is a livelock?

0 Answers  


What is the difference RDBMS and Graph Database?

0 Answers   EXL,


What are the steps you should follow to start sql server in single-user mode?

0 Answers  


What is difference between Triggers and store procedure?

2 Answers  


Can you force a query to use a specific index?

0 Answers  


Can we use pragma autonomous_transaction in trigger?

0 Answers  


What is the difference between DataRow.Delete() and DataRow.Remove()?

0 Answers  


Explain data warehousing in sql server?

0 Answers  


Can we use custom code in ssrs?

0 Answers  


What is master database? : SQL Server Architecture

0 Answers  


Categories