Interested to Buy Any Domain ? << Click Here >> for more details...
if 3 duplicate records in a table,i want to delete 2 duplicate
records by keeping 1 as it is,how?
- 1 Answers
- 3674 Views
- I also Faced
- E-Mail Answers
Answer / venkat
if u r table like this
sno sname fee
1 a 1000
1 a 1000
2 b 1000
2 b 1000
3 c 1000
3 c 1000
--- write this
with duplicatecte
as
(select row_number()over(partition by sno,sname order by fee
)as rnum from students )
delete from dupcte where rnum>1
---run this query
select * from students
--out put is
1 a 1000
2 b 1000
3 c 1000
this is correct
| Is This Answer Correct ? | 2 Yes | 0 No |
Do you know what is sql service broker?
How do you delete duplicate records in sql server?
Difference Between varchar and nvarchar datatype?
What is 1nf normalization form?
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
What are the restrictions while creating batches in sql server?
How do you rename a table in sql server?
What is raid and what are different types of raid levels?
How to use values from other tables in update statements in ms sql server?
What is scheduled job and how to create it?
How to write stored procedure to update the data in 10 tables
What is self join in sql server joins?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
