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?

Answer Posted / satishkulala

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

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which table keeps the locking information?

879


How to change a login name in ms sql server?

1023


What is a data source file?

919


Differentiate between a primary key and a unique key.

998


What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1206


What is the downside of using udf?

1041


What is the use of group by clause?

897


whats the maximum size of view state??

2146


What are data driven subscriptions?

104


what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

919


How to create a simple stored procedure in ms sql server?

971


How would you use user_constraints table in DB?

936


What is a deadlock and what is a live lock?

951


What are the kinds of subquery?

946


What is temporal data type?

868