DELETE FROM 테이블명
WHERE ROWID IN (
SELECT ROWID FROM (
SELECT * FROM (
SELECT ROW_NUMBER() OVER(PARTITION BY 컬럼명 ORDER BY 컬럼명) AS num
FROM 테이블명
)
WHERE num > 1 (-> num의 값이 1초과인 데이터들만 삭제)
)
);
출처: https://rahm.tistory.com/52 [RAHM]
SELECT ROWID FROM (
SELECT * FROM (
SELECT ROW_NUMBER() OVER(PARTITION BY billindex ORDER BY billindex) AS num
FROM billinfo_detail
)
WHERE num > 1
);
URLRewrite = Y,
URLRewriteConfig = "{webtob_home}/config/rewrite.conf",
rewrite.conf를 다음과 같이 생성한다.
http -> https 변경
RewriteCond %{HTTPS} !=on
RewriteRule ^/?(.*) https://%{SERVER_NAME}:$0 [R,L]
RewriteCond %{HTTPS} !=on
RewriteRule ^/?(.*) https://%{SERVER_NAME}:444:/$1 [L]
* 특정도메인 호출시 특정페이지 이동
RewriteCond %{HTTP_HOST} ^www\.koti\.re\.kr$
RewriteRule ^/$ /index.do [L]
RewriteCond %{HTTP_HOST} ^m\.koti\.re\.kr$
RewriteRule ^/$ /m/index.do [L]
RewriteCond %{HTTP_HOST} ^english\.koti\.re\.kr$
RewriteRule ^/$ /english/index.do [L]
* http로 특정 url 호출시 https로 변경
RewriteCond %{REQUEST_URI} /login/*
RewriteCond %{SERVER_PORT} 80
RewriteRule .* https://%{SERVER_NAME}%{REQUEST_URI} [R,L]
RewriteCond %{REQUEST_URI} /user/join/*
RewriteCond %{SERVER_PORT} 80
RewriteRule .* https://%{SERVER_NAME}%{REQUEST_URI} [R,L]
RewriteCond %{REQUEST_URI} /user/purchase/*
RewriteCond %{SERVER_PORT} 80
RewriteRule .* https://%{SERVER_NAME}%{REQUEST_URI} [R,L]
