단가5를 10% DC해서 단가6에 넣기 (round는 반올림, 버림은 Trunc; -2는 십의 자리, 일의 자리로 하려면 -1)
update bas_proddetail set pmdg06 = round(pmdg05 * 9 /10, -2)
update bas_proddetail set pmdg06 = ceil(pmdg05 * 9/10 * power(10, 1))/power(10, 1)) //십의 자리에서 올림
update bas_proddetail set pmdg06 = ceil(pmdg05 * 9/10 * power(10, 2))/power(10, 2)) //백의 자리에서 올림
    아래는 "=" 오른쪽에 들어갈 내용
    HIY: 할인율, MCJRS: 처리 자리수(3:백의 자리, 2:십의 자리, 1:일의 자리, -1:소수첫째자리, -2:소수둘째자리)
    vStr:= '(SBJAMT * (100 - ' + FloatToStr(HIY) + ')/100)';
    반올림
      if MCJRS < 0 then Result:= 'floor(' + vStr + ' * Power(10, ABS(MCJRS - 1) + 0.5 ) / Power(10, ABS(MCJRS) - 1)'
      else Result:= 'floor('  + vStr + ' / Power(10, MCJRS) + 0.5) * Power(10, MCJRS)';
    올림
      if MCJRS > 0 then Result:= 'Ceil(' + vStr + ' / Power(10, MCJRS)) * Power(10, MCJRS)'
      else Result:= 'Ceil(' + vStr + ' * Power(10, ABS(' + IntToStr(MCJRS) + ') - 1)) /Power(10, ABS(MCJRS) - 1)'
    버림
      if MCJRS < 0 then Result:= 'floor(' + vStr + ' * Power(10, ABS(MCJRS) - 1)) / Power(10, ABS(MCJRS) - 1)'
      else Result:= 'floor(' + vStr + ' / Power(10, MCJRS)) * Power(10, MCJRS)';


최종단가 없애기
update bas_mcbuyer set lastdggb = "N"

마일리지 이상 적립 시-쿼리 후 전자료에서 새로 적립
update sal_salemaster set JRAMT = 0 where jpno = '전표번호'
delete from mbr_grhistory where jpno = '전표번호'

마일리지 조정
update mbr_member set jrycash = 0.3, jrycashysj = 0.1, jrycard = 0.1

필드길이: CHAR_LENGTH
select Barcode from bas_proddetail where CHAR_LENGTH(barcode)>20

업데이트
UPDATE SAL_SALEMASTER SET GJJPNO = ''' + GJJPNO + ''' WHERE JPNO = ''' + JPNO + '''';

테이블 일부 자료 삭제
delete From bas_itemmodihist where workdate < '2019-10-01'
delete from sal_salemaster where ilja < '2019-10-01' and buyercd = '' and buyernm = ''
delete from sal_saledetail where ilja < '2019-10-01' and buyercd = '' and buyernm = ''
delete from sal_histsalemaster where ilja < '2019-10-01' and buyercd = '' and buyernm = ''
delete from sal_histsaledetail where ilja < '2019-10-01' and buyercd = '' and buyernm = ''
delete from bas_histproduct where workdt < '2019-10-01 00:00:00'
delete from sal_histproddetail where workdt < '2019-10-01 00:00:00' 
delete from sal_cardjp where ilja < '2019-10-01'
delete from sal_cashysj where ilja < '2019-10-01'

전체 테이블 삭제
delete From acc_accja
delete From acc_junpyo
delete From bas_histmcbuyer
delete From bas_histmibuyer
delete From bas_histproddetail
delete From bas_histproduct
delete From bas_itemmodihist
delete From bas_mcbuyer
--delete From bas_pdstock
--delete From bas_pdstockjj
--delete From mbr_grhistory
--delete From mbr_member
--delete From mbr_mileage
--delete From mbr_milechange
--delete From sal_baseamt
--delete From sal_bjdetail
--delete From sal_bjinfo
--delete From sal_cardjp
--delete From sal_cashysj
--delete From sal_eventprod
--delete From sal_gjdetail
--delete From sal_gjinfo
--delete From sal_histmidetail
--delete From sal_histmiinfo
--delete From sal_histsaledetail
--delete From sal_histsalemaster
--delete From sal_igjg
--delete From sal_jainfo
--delete From sal_jajojung
--delete From sal_lastprice
--delete From sal_midetail
--delete From sal_miinfo
--delete From sal_saledetail
--delete From sal_salemaster
--delete From sal_saleend
--delete From sal_sjdetail
--delete From sal_sjinfo
--delete From sal_taxinfo
--delete From sys_irno

두 테이블 비교해서 Update
Merge into bas_product a using bas_proddetail b on a.pdcode = b.pdcode and a.sbjamt = 0 and b.sbjamt <> 0 and a.meqty = b.meqty and b.qty = 1 when matched then  update set a.SBJAMT = b.sbjamt