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

What are the different authentication modes in sql server? How can it be changed?

1133


What do you understand by the data quality services in sql server?

979


What is the use of RDBMS?

1052


Can a database be shrunk with users active?

1189


What is raid and what are different types of raid levels?

1191


What is resource db in sql server?

1054


Explain collation?

1099


When columns are added to existing tables, what do they initially contain?

1092


Is resultset an interface?

1036


what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1048


what types of replication are supported in sql server? : Sql server database administration

1125


What is cached report?

150


What is abstracting periodical?

986


What are the different types of collation sensitivity in sql server?

1156


What are the differences between stored procedure and the dynamic sql?

1134