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...

write a query for how to eliminate the duplicate rows
without using distinct?

Answer Posted / abhishek kumar

select id from tgt_table group by id;

Is This Answer Correct ?    7 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to generate sequence numbers?

1082


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2740


What are the modules in Power Center

1674


The question was on time stamp. what is the difference between HH and HH24 when to use when.

2051


What are the differences between a connected lookup and unconnected lookup?

1065


How to load a Dimension ? and how to load a fact table?

1408


How can you differentiate between powercenter and power map?

1083


whats the logic to load the lower level of granularity of data to fact table.

2269


How can repository reports be accessed without sql or other transformations?

1209


What are the informatica performance improvement tips

1086


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1895


According to his methodology what all you need before you build a datawarehouse

1752


How do you handle two sessions in Informatica

1147


What is joiner transformation in informatica?

1043


tell me about your project functionality

2339