논문준비

sql

use hiblue

select top 10 * from dynasty select top 10* from emporor

select e.emperor_id, e.name as emperorName, d.dynasty_id, d.name as dynastyName, e.short_name_eng from dynasty d , emporor e where e.dynasty_id=d.dynasty_id select top 10 * from t_month select top 10 * from t_era select top 10 * from t_era_names

select * from era select era_id, name as eraName, emperor_id, language_id into era from t_era , t_era_names where t_era.id=t_era_names.era_id select e.emperor_id, e.name as emperorName, d.dynasty_id, d.name as dynastyName, era_id, eraname, language_id, e.short_name_eng from dynasty d , emporor e, era where e.dynasty_id=d.dynasty_id and e.emperor_id=era.emperor_id

select distinct e.emperor_id, d.dynasty_id, era_id into yearLink from dynasty d , emporor e, era where e.dynasty_id=d.dynasty_id and e.emperor_id=era.emperor_id

select * from yearLink

use hiblue

select * from t_month select * from 번역연호 select distinct 나라_한글, 나라_한자, 지역 into k_dynasty from 번역연호 select distinct 묘호_한글, 묘호_한자, 시호_한글, 시호_한자, 휘이름 into k_emperor from 번역연호 select distinct 서기, 단기, 간지 into k_year from 번역연호 select distinct 서기, 나라_한글, 휘이름 into k_yearLink from 번역연호