How to delete only one row from duplicate rows in Oracle SQL?

[Rn] 7s^2 · 2014-09-23T19:51:45+00:00

I have the following table: Name Address VCR Mumbai VCR Mumbai Now there are 2 rows and they are duplicate. How can I delete the second row or first row so that only one row is present? I tried: Delete from stud where name = 'VCR' limit 1; But it is giving me error. Please help.

How bout using your brain
Guest

Sep 23, 2014 01:11 PM

Don't you have a primary key defined?

Next Oldest | Next Newest

New Reply

Possibly Related Threads...
Thread / Author	Replies	Views	Last Post
How to make a program or DB to send Excel rows in email by AnGrY BoMay 17, 2018 01:19 PM	4	135	May 17, 2018 01:19 PM Last Post: AnGrY Bo
Remove everything BUT duplicate values? by RenovatumMar 2, 2018 01:48 PM	3	168	Mar 2, 2018 01:48 PM Last Post: Renovatum
[Help] How to Extract Next Rows on iMacros by multiscreenMar 18, 2017 05:31 AM	0	106	Mar 18, 2017 05:31 AM Last Post: multiscreen

View a Printable Version
Export as PDF
Subscribe to this thread

Login
Username/Email:
Password:	Lost Password?
	Remember me