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 to select the duplicate rows from a table?

Answer Posted / pandu

select distinct from <field name> from <table name>

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are concurrency issues?

1044


What is database reorganization?

1070


What is declare cursor?

1060


What are the various isolation levels possible?

1060


How to resolve deadlock issue

19923


On which levels locks can be applied?

1070


Is the primary key a clustered index?

1088


What is with ur in db2?

1261


What type of database is db2?

923


What are catalog tables in db2?

1003


What do you mean by storage group (stogroup)?

1000


What is db2?

1135


What is scrollable cursor in db2?

1014


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1677


Why select is not preferred in embedded sql programs?

1251