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 sub query for eliminating duplicate rows using
analytical function?

Answers were Sorted based on User's Feedback



write sub query for eliminating duplicate rows using analytical function?..

Answer / korimantu

delete from table name where rowid not in(select max(rowid)
from group by last_name);

or

delete from table name where rowid>(select min(rowid) from
where a.last_name=b.last_name);

Is This Answer Correct ?    4 Yes 2 No

write sub query for eliminating duplicate rows using analytical function?..

Answer / vyshak

delete from table where rowid not in (select max(rowid) from
table group by all column names);

or

delete (dense_rank() over(partition by all column names))dn
from table where dn>2;

Is This Answer Correct ?    4 Yes 3 No

write sub query for eliminating duplicate rows using analytical function?..

Answer / guest

select distinct

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

What are the differences between Database Trigger and Integrity constraints ?

4 Answers  


What is the difference between left join and left outer join?

1 Answers  


what is the difference between join and union? : Sql dba

0 Answers  


How does one load ebcdic data? : aql loader

0 Answers  


How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

3 Answers   TCS,


How many aggregate functions are available there in sql?

0 Answers  


what is a database lock ? : Sql dba

0 Answers  


What is the current version of sql?

0 Answers  


What are Anti joins

1 Answers   IBM,


What is meant by Join? What are the different types of Joins available? Explain.

5 Answers   Cap Gemini,


what is the cursor and use of cursor in pl/sql ?

4 Answers  


What is constant in pl sql?

0 Answers  


Categories