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
- 3716 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 |
What is the use of stored procedure?
How to apply cascading referential integrity in place of triggers?
What are the difficulties faced in cube development? : sql server analysis services, ssas
What do you understand by recursive stored procedure?
Explain what is the main purpose of having conversation group?
Differentiate between ms sql server reporting services vs crystal reports?
What is a Lock and let me know Different types of locks?
What are pages and extents? : SQL Server Architecture
What is an indexing technique?
What is sub query and its properties?
How do you create type- insensitive operator?
Differences between functions and stored procedures?
8 Answers 247Customer, Accenture,
-
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)
