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
- 3616 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 @@spid?
How many instances per computer are there in sql server 2000?
Where the sql logs gets stored? : sql server database administration
What is wide table?
What is the difference between a Application Server and a Database
What are points to remember while using the fillfactor argument?
What is the difference between a local and a global variable?
What are the different types of replication? How are they used?
What is the difference between a Local temporary table and a Global temporary table? How is each one used?
How to implement service broker?
What is the most common trace flags used with sql server?
How will you find out if there are expensive SQL statements running or not?
-
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)
