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

In what sequence sql statement is processed?

999


What is query optimization process?

1001


Explain what is log shipping?

1129


What is self contained multi valued query?

1003


What are the ways available in sql server to execute sql statements?

1105


How do I find the port number for sql server?

964


What is fill factor and pad index?

1005


How to list all objects in a given schema?

1050


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1934


What are the differences between triggers and stored procedures?

1055


How to configure odbc dsn with different port numbers?

1077


When would you prefer to have a minimum number of indexes?

894


What is the difference between executequery () and executeupdate ()?

1020


What is cached report?

143


What are the different types of subquery?

1143