Run Code
|
Code Wall
|
Users
|
Misc
|
Feedback
|
About
|
Login
|
Theme
|
Privacy
SQL Server - Eliminar Registros Duplicados
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
CREATE TABLE Ventas ( fecha_venta date, monto_venta decimal, F tinyint, M tinyint ) INSERT INTO Ventas VALUES ('20170919', 3521, 2, 2), ('20170920', 3522, 2, 2), ('20170920', 3522, 2, 2), ('20170921', 3522, 2, 2), ('20170921', 3522, 2, 2), ('20170921', 3522, 2, 2) SELECT * FROM Ventas ;WITH REGISTRO_DUPLICADO AS( SELECT INDICE = ROW_NUMBER() OVER (PARTITION BY fecha_venta, monto_venta, F, M ORDER BY fecha_venta), * FROM Ventas ) DELETE FROM REGISTRO_DUPLICADO WHERE INDICE > 1; SELECT * FROM Ventas
View schema
Execution time: 0,02 sec, rows selected: 9, rows affected: 9, absolute service time: 0,16 sec
edit mode
|
history
fecha_venta
monto_venta
F
M
1
19.09.2017 00:00:00
3521
2
2
2
20.09.2017 00:00:00
3522
2
2
3
20.09.2017 00:00:00
3522
2
2
4
21.09.2017 00:00:00
3522
2
2
5
21.09.2017 00:00:00
3522
2
2
6
21.09.2017 00:00:00
3522
2
2
fecha_venta
monto_venta
F
M
1
19.09.2017 00:00:00
3521
2
2
2
20.09.2017 00:00:00
3522
2
2
3
21.09.2017 00:00:00
3522
2
2