Run Code
|
Code Wall
|
Users
|
Misc
|
Feedback
|
About
|
Login
|
Theme
|
Privacy
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
Please
log in
to post a comment.
BT SQL Project
OUTPUT CLUASE
Joins outside XML element
Combined Where and having
Time Difference Calculation (amended v2)
SQL Stringdata
WORK
Transpose group per sequence
select all tables from given schema
kirthi
Please log in to post a comment.