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 / rajesh.a

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

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What command do we use to rename a db, a table and a column?

885


Define tool Manage Statistics in SQL Server 2000 query ?

1037


Write a SQL query in order to merge two different columns into single column?

999


Which sql server table is used to hold the stored procedure script?

898


Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1007


What is 5nf in normalization form?

950


What is temporal data type?

885


What do you mean by a dependent functionality in a build?

1076


How do you improve the performance of a SQL Azure Database?

135


What are the operating modes in which database mirroring runs?

1046


What does <> symbol mean?

929


how you can configure a running aggregate in SSRS?

188


Working with TLogs

1795


Why use identity in sql server?

1034


Explain what is the function of sql server agent windows service?

958