how to delete four out of five duplicate records in a table
using sql
- 1 Answers
- 2077 Views
- I also Faced
- E-Mail Answers
Answer Posted / Minaxi Kumari
To delete four out of five duplicate records in a table using SQL, you can use the ROW_NUMBER() window function as follows:
1. Assign a row number to each record.
2. Delete all but the first (row number 1) of each set of duplicates.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please send me Sample papers National Informatics Centre (NIC) Programmer. I am giving this paper first time..so if any one have previous question papers send to manoj200.yadav@gmail.com. thnx in advance
Write a function that responds to a click anywhere on the page by displaying an alert dialog. Display the event name if the user held Shift during the mouse click. Display the element name that triggered the event if the user held Ctrl during the mouse click.
What have you done to improve or develop your knowledge / professional qualifications in the last year?
plz snd me sbi probationofficers papers to my id archpa@gmail.com
please provide me the type of questions or question pattern of bally.
am looking for ms,i got ielts score 5.5,and i dont have english score 60 in any any year.tell me can i get offer lettr from any university.is i am elegible..?
hi, please send me "state bank of india", last 5 years question paper with answers to my mail id.
I have applied for the post of Section Engineer. plz anyone send me the previous question paper. i did my engineering in Information Technology.
What is Campus selection process of patni at Adcet,Ashta at 24th dec 2010.Also give apti syllabus.
can you provide me uniken pvt ltd. technical interview question and answer?
can any one send me the configuration of cisco 1841 router????/
What is the instruction to load the register B?
Please send me Sample papers OF National Informatics Centre (NIC) Vacency
i need the placement paper of ford IT service...
Iam preparing for Visakhapatnam Management Trainee 2009 entrance exam.. If anybody have Visakhapatnam Management Trainee Interview questions Pls forward to my mail id srikanth.avanthi@gmail.com .. It is kindly request..
