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

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

945


Tell me what is the difference between locking and multi-versioning?

1031


What is thr feature of change data capture?

980


What are the difference between clustered and a non-clustered index?

1043


How we create SQL Server 2005 Reporting Services ? Give me Sample

1993


How to use user defined functions in expressions?

1092


What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

973


Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

944


Explain what are the basic functions for master, msdb, model, tempdb databases?

980


How do I perform an unattended install of sql server 2000?

1086


how you can get the list of largest tables in a database? : Sql server administration

1053


What are views in ms sql server?

1085


What is the difference between a function and a stored procedure?

1072


What is sql azure database?

206


What is an indexing technique?

936