곰곰히 생각해보면

엑셀의 특정 값을 특정 범위의 값과 비교하여 변경하고 싶다면?

이러한 기준표가 있다면!

점수 점수표기 범주
0    F 0~59
60  D0 60~64
65  D+ 65~69
70  C0 70~74
75   C+ 75~79
80   B0 80~84
85  B+ 85~89
90  A0 90~94
95   A+ 95~100

VLOOKUP 처리 후 나오는 값
표기1 =VLOOKUP(E:E,A:C,2,0)
표기2 =VLOOKUP(F:F,B:D,2,0)

기준값 표기1 표기2
0 F 0~59
60 D0 60~64
65 D+ 65~69
70 C0 70~74
75 C+ 75~79
80 B0 80~84
85 B+ 85~89
90 A0 90~94
95 A+ 95~100

# mysql
db.database=mysql
#Local set
#db.url=jdbc:log4jdbc:mysql://localhost:3306/#DBName 
db.url=jdbc:log4jdbc:mysql://IP:Port/#DBName
db.username=#ID db.password=#PW
db.driverClassName=com.mysql.db.Driver
#mysql DB config
db.conn.maxTotal=50 db.conn.maxIdle=5
db.conn.maxWaitMillis=30
db.conn.validationQuery=SELECT 1;
db.conn.validationInterval=30000
db.conn.testWhileIdle=true
db.conn.removeAbandoned=true
db.conn.removeAbandonedTimeout=60
#######################################################

# mssql
jdbc.db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver jdbc.db.url=jdbc:sqlserver://IP:Port;DataBaseName=#DBName
jdbc.db.username=#ID
jdbc.db.password=#PW
jdbc.db.conn.maxTotal=50
jdbc.db.conn.maxIdle=5
jdbc.db.conn.maxWaitMillis=30
jdbc.db.conn.validationQuery=SELECT 1;
jdbc.db.conn.removeAbandonedTimeout=60
#######################################################

# oracle
jdbc.db.driver=oracle.jdbc.driver.OracleDriver
jdbc.db.url=jdbcc:oracle:thin:@IP:Port:#DBName
jdbc.db.username=#ID
jdbc.db.password=#PW
#oracle DB config
jdbc.db.conn.maxTotal=50
jdbc.db.conn.maxIdle=5
jdbc.db.conn.maxWaitMillis=30
jdbc.db.conn.validationQuery=SELECT 1;
jdbc.conn.removeAbandonedTimeout=60

[SQL]
select cast('202101'+'31' as date) as 원하는달마지막날표기
,dateadd(month,5,cast('202101'+'31' as date)) as 원하는달5개월후마지막날표기
,left(REPLACE(dateadd(month,5,cast('202101'+'31' as date)),'-',''),6) as 원하는달5개월후년월표기기호생략

[view]
2021-01-31 원하는달마지막날표기 
2021-06-30 원하는달5개월후마지막날표기 
202106      원하는달5개월후년월표기기호생략