å建表ä¾åºåï¼è¡¨ä¸æ4个å段ï¼ä¾åºå代ç ï¼å符åï¼ï¼æ§å«ï¼å符åï¼ï¼æå¨åå¸ï¼å符åï¼ï¼èç³»çµè¯ï¼å符åï¼ã
create table ä¾åºå (ä¾åºå代ç char(10), æ§å« char(2), æå¨åå¸ char(20), èç³»çµè¯ char(32));
æ±ä¾åºå·¥ç¨J1ä¸é¶ä»¶P1çä¾åºåå§åï¼
select a.ä¾åºåå§å from ä¾åºå a, å·¥ç¨ b, é¶ä»¶ c, ä¾åºé¶ä»¶ d where a.ä¾åºå代ç =d.ä¾åºå代ç and b.å·¥ç¨ä»£ç =d.å·¥ç¨ä»£ç and c.é¶ä»¶ä»£ç =d.é¶ä»¶ä»£ç and b.å·¥ç¨å='J1' and c.é¶ä»¶å='P1';
æ±ä¾åºå·¥ç¨J1é¶ä»¶ä¸ºçº¢è²çä¾åºå代ç ï¼
select a.ä¾åºåå称 from ä¾åºå a, é¶ä»¶ b, ä¾åºé¶ä»¶ c
where a.ä¾åºå代ç =c.ä¾åºå代ç and b.é¶ä»¶ä»£ç =c.é¶ä»¶ä»£ç and b.é¶ä»¶ä»£ç ='J1' and b.é¢è²='红è²';
æ±ä¾åºå代ç åå
¶ä¾åºçå·¥ç¨æ°ï¼
select ä¾åºå代ç , count(1) from ä¾åºé¶ä»¶;
æ±æ¢ä¸ºå·¥ç¨J1ä¾åºé¶ä»¶ï¼å为工ç¨J2ä¾åºé¶ä»¶çä¾åºå代ç ï¼
select a.ä¾åºå代ç from ä¾åºé¶ä»¶ a, å·¥ç¨ b where a.å·¥ç¨ä»£ç =b.å·¥ç¨ä»£ç and b.å·¥ç¨å称 in ('J1','J2');
å¨è¡¨å·¥ç¨ä¸æ·»å ä¸ä¸ªè®°å½ï¼å·¥ç¨ä»£ç 为0001ï¼å·¥ç¨å为æææºå¶é ï¼è´è´£äººä¸ºæå¹³ï¼é¢ç®ä¸º70000å
ã
INSERT INTO å·¥ç¨ (å·¥ç¨ä»£ç ,å·¥ç¨å,è´è´£äºº,é¢ç®) values ('0001','æææºå¶é ','æå¹³',70000);
温馨提示:答案为网友推荐,仅供参考