Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Duplicate Records
create table em( id int, name varchar(50) ) insert into em values (1,'A'),(2,'B'), (3, 'B'),(4, 'C'), (5, 'C'),(6, 'D'), (7, 'E'),(8, 'F') select * from em ; with cte as ( select *, row_number() over (partition by name order by id)rw from em ) select * from em where name in (select name from cte where rw> 1)
run
|
edit
|
history
|
help
0
QLDT_TUAN 7
SQL HW 1 Appline
Select empID whose salary is greater than their managers
SQL Interview Questions : Customer Orders
c12part2
MLK Date
Consecutive publisher publish more than 2 books for 3 days
MY SQL
Libros
Stuff code in sql