문상연 2017.11.30 13:20 Views : 8903
1부터 100까지의 데이타 행이 있다면 5,34, 89, 46 , 79를 제외한 모든 데이타를 삭제를 할려면 어떻게 해야하나요?
2017.11.30 14:57
(code varchar(10) null)insert into A values ('1'),('2'),('3'),('4'),('5')select * from A
with B as
(select ROW_NUMBER() OVER(ORDER BY code) as iNo from A )
delete from B where iNo Not in ('2','4')
cmd_comment_vote_user Upvote0 Downvote0
2017.11.30 20:03
고맙습니다
Keep me signed in.
(code varchar(10) null)
insert into A values ('1'),('2'),('3'),('4'),('5')
select * from A
with B as
(
select ROW_NUMBER() OVER(ORDER BY code) as iNo from A
)
delete from B where iNo Not in ('2','4')