sql语句练习，有兴趣的同学可以一起做，来对对答案【正德职业技术学院吧】_百度贴吧
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&签到排名：今日本吧第个签到，本吧因你更精彩，明天继续来努力！
本吧签到人数：0成为超级会员，使用一键签到本月漏签0次！成为超级会员，赠送8张补签卡连续签到：天&&累计签到：天超级会员单次开通12个月以上，赠送连续签到卡3张
关注：40,142贴子：
sql语句练习，有兴趣的同学可以一起做，来对对答案收藏
//数据库//创建练习的数据库CREATE TABLE STUDENT(SNO VARCHAR(3) NOT NULL,SNAME VARCHAR(4) NOT NULL,SSEX VARCHAR(2) NOT NULL,SBIRTHDAY DATETIME,CLASS VARCHAR(5))goCREATE TABLE COURSE(CNO VARCHAR(5) NOT NULL,CNAME VARCHAR(10) NOT NULL,TNO VARCHAR(10) NOT NULL)goCREATE TABLE SCORE(SNO VARCHAR(3) NOT NULL,CNO VARCHAR(5) NOT NULL,DEGREE NUMERIC(10, 1) NOT NULL)goCREATE TABLE TEACHER(TNO VARCHAR(3) NOT NULL,TNAME VARCHAR(4) NOT NULL, TSEX VARCHAR(2)NOT NULL,TBIRTHDAY DATETIME NOT NULL, PROF VARCHAR(6),DEPART VARCHAR(10) NOT NULL) INSERT INTO STUDENT(SNO,SNAME,SSEX,SBIRTHDAY,CLASS) VALUES (108 ,'曾华','男',,95033);INSERT INTO STUDENT(SNO,SNAME,SSEX,SBIRTHDAY,CLASS) VALUES (105 ,'匡明','男',,95031);INSERT INTO STUDENT(SNO,SNAME,SSEX,SBIRTHDAY,CLASS) VALUES (107 ,'王丽','女',,95033);INSERT INTO STUDENT(SNO,SNAME,SSEX,SBIRTHDAY,CLASS) VALUES (101 ,'李军','男',,95033);INSERT INTO STUDENT(SNO,SNAME,SSEX,SBIRTHDAY,CLASS) VALUES (109 ,'王芳','女' ,,95031);INSERT INTO STUDENT(SNO,SNAME,SSEX,SBIRTHDAY,CLASS) VALUES (103 ,'陆君','男',,95031);GOINSERT INTO COURSE(CNO,CNAME,TNO)VALUES('3-105' ,'计算机导论',825)INSERT INTO COURSE(CNO,CNAME,TNO)VALUES('3-245' ,'操作系统' ,804);INSERT INTO COURSE(CNO,CNAME,TNO)VALUES('6-166' ,'数据电路' ,856);INSERT INTO COURSE(CNO,CNAME,TNO)VALUES('9-888' ,'高等数学' ,100);GOINSERT INTO SCORE(SNO,CNO,DEGREE)VALUES(103,'3-245',86);INSERT INTO SCORE(SNO,CNO,DEGREE)VALUES(105,'3-245',75);INSERT INTO SCORE(SNO,CNO,DEGREE)VALUES(109,'3-245',68);INSERT INTO SCORE(SNO,CNO,DEGREE)VALUES(103,'3-105',92);INSERT INTO SCORE(SNO,CNO,DEGREE)VALUES(105,'3-105',88);INSERT INTO SCORE(SNO,CNO,DEGREE)VALUES(109,'3-105',76);INSERT INTO SCORE(SNO,CNO,DEGREE)VALUES(101,'3-105',64);INSERT INTO SCORE(SNO,CNO,DEGREE)VALUES(107,'3-105',91);INSERT INTO SCORE(SNO,CNO,DEGREE)VALUES(108,'3-105',78);INSERT INTO SCORE(SNO,CNO,DEGREE)VALUES(101,'6-166',85);INSERT INTO SCORE(SNO,CNO,DEGREE)VALUES(107,'6-106',79);INSERT INTO SCORE(SNO,CNO,DEGREE)VALUES(108,'6-166',81);GOINSERT INTOTEACHER(TNO,TNAME,TSEX,TBIRTHDAY,PROF,DEPART)VALUES (804,'李诚','男','','副教授','计算机系');INSERT INTOTEACHER(TNO,TNAME,TSEX,TBIRTHDAY,PROF,DEPART)VALUES (856,'张旭','男','','讲师','电子工程系');INSERT INTOTEACHER(TNO,TNAME,TSEX,TBIRTHDAY,PROF,DEPART)VALUES (825,'王萍','女','','助教','计算机系');INSERT INTOTEACHER(TNO,TNAME,TSEX,TBIRTHDAY,PROF,DEPART)VALUES (831,'刘冰','女','','助教','电子工程系');
查询Student表中的所有记录的Sname、Ssex和Class列。Select
Sname,SSex,Class
from student 2、
查询教师所有的单位即不重复的Depart列。select distinct(depart)from teacher3、
查询Student表的所有记录。select * from student4、
查询Score表中成绩在60到80之间的所有记录。select * from score whereDEGREE between 60 and 80 select * from score whereDEGREE &60 and
DEGREE &805、
查询Score表中成绩为85，86或88的记录。select * from score whereDEGREE in(85,86,88)6、
查询Student表中“95031”班或性别为“女”的同学记录。select * from studentwhere SSex='女' and select * from studentwhere SSex='女' or7、
以Class降序查询Student表的所有记录。select * from studentorder by Class desc8、
以Cno升序、Degree降序查询Score表的所有记录。select * from score order by Cno asc,Degree desc9、
查询“95031”班的学生人数。
select COUNT(*)as 人数 from Student group by class having
select COUNT(*)as 人数 from Student where class='95031'10、查询Score表中的最高分的学生学号和课程号。 select Sno,cno from score where DEGREE=(select MAX(degree)from score)11、查询‘3-105’号课程的平均分。 select AVG(DEGREE)as 平均分 from SCORE whereSNO='3-105'12、查询Score表中至少有5名学生选修的并以3开头的课程的平均分数。select AVG(degree)as 平均分 from SCORE where cno like '3%'
group by cno having COUNT(cno)&=5
selectAVG(degree)as 平均分 from SCORE where cnolike '3%'
group by cno havingCOUNT(*)&=513、查询最低分大于70，最高分小于90的Sno列。select student. sno fromScore
,student where
score.sno=student.sno and (score.degreebetween 70 and 90 )
select student. sno from Score
,student where
score.sno=student.sno and (score.degree&70 and score.degree& 90 )14、查询所有学生的Sname、Cno和Degree列
selectstudent.Sname,score.sno,score.Degree from student ,score
student.sno=score.sno
select st.sname,sc.sno,sc.degree from student as st join score as sc onst.sno= sc.sno15、查询所有学生的Sno、Cname和Degree列。select a.cname,b.sno,b. DEGREE from
course as a join score as b on
a.cno=b.cno select a.cname,b.sno,b. DEGREE from
course as a , score as b
where a.cno=b.cno16、查询所有学生的Sname、Cname和Degree列。
select st.sname,sc.degree,sr.cname fromstudent as st ,score as sc ,course as sr
where sc.sno=st.snoand sc.cno=sr.cno
selectst.sname,sc.degree,sr.cname from (student as st join score
sc.sno=st.sno )inner join course as sr
on sc.cno=sr.cno17、查询“95033”班所选课程的平均分。select AVG(degree) as 平均分 from score as sc ,student as st where sc.sno=st.snoand st.class='95033'
select AVG(degree)as 平均分 from score as sc join
student as st
on sc.sno=st.sno where st.class='95033'18、假设使用如下命令建立了一个grade表：create table grade(low
numeric (3,0),upp
numeric (3),rank
char(1));insert into grade values(90,100,’A’);insert into grade values(80,89,’B’);insert into grade values(70,79,’C’);insert into grade values(60,69,’D’);insert into grade values(0,59,’E’);现查询所有同学的Sno、Cno和rank列。
SELECTA.SNO,A.CNO,B.RANK FROM SCORE A,GRADE B WHERE A.DEGREE BETWEEN B.LOW AND B.UPP ORDER BY RANK;19、查询选修“3-105”课程的成绩高于“109”号同学成绩的所有同学的记录。20、查询score中选学一门以上课程的同学中分数为非最高分成绩的记录。21、查询成绩高于学号为“109”、课程号为“3-105”的成绩的所有记录。22、查询和学号为108的同学同年出生的所有学生的Sno、Sname和Sbirthday列。23、查询“张旭“教师任课的学生成绩。24、查询选修某课程的同学人数多于5人的教师姓名。25、查询95033班和95031班全体学生的记录。26、查询存在有85分以上成绩的课程Cno.27、查询出“计算机系“教师所教课程的成绩表。28、查询“计算机系”与“电子工程系“不同职称的教师的Tname和Prof。29、查询选修编号为“3-105“课程且成绩至少高于选修编号为“3-245”的同学的Cno、Sno和Degree,并按Degree从高到低次序排序。30、查询选修编号为“3-105”且成绩高于选修编号为“3-245”课程的同学的Cno、Sno和Degree.31、查询所有教师和同学的name、sex和birthday.32、查询所有“女”教师和“女”同学的name、sex和birthday.33、查询成绩比该课程平均成绩低的同学的成绩表。34、查询所有任课教师的Tname和Depart.35
查询所有未讲课的教师的Tname和Depart.36、查询至少有2名男生的班号。37、查询Student表中不姓“王”的同学记录。38、查询Student表中每个学生的姓名和年龄。39、查询Student表中最大和最小的Sbirthday日期值。40、以班号和年龄从大到小的顺序查询Student表中的全部记录。41、查询“男”教师及其所上的课程。42、查询最高分同学的Sno、Cno和Degree列。43、查询和“李军”同性别的所有同学的Sname.44、查询和“李军”同性别并同班的同学Sname.45、查询所有选修“计算机导论”课程的“男”同学的成绩表
参考答案参考答案：1. SELECT SNAME,SSEX,CLASS FROM STUDENT; 2. SELECT DISTINCT DEPART FROM TEACHER; 3. SELECT * FROM STUDENT; 4. SELECT * FROM SCORE WHERE DEGREE BETWEEN60 AND 80; 5.SELECT * FROM SCORE WHERE DEGREE IN(85,86,88); 6. SELECT * FROM STUDENT WHERECLASS='95031' OR SSEX='女'; 7.SELECT * FROM STUDENT ORDER BY CLASSDESC; 8.SELECT * FROM SCORE ORDER BY CNOASC,DEGREE DESC; 9.SELECT COUNT(*) FROM STUDENT WHERE; 10.SELECT SNO,CNO FROM SCORE WHEREDEGREE=(SELECT MAX(DEGREE) FROM SCORE); SELECT SNO,CNO FROM SCORE ORDER BY DEGREEDESC LIMIT 1; 11.SELECT AVG(DEGREE) FROM SCORE WHERECNO='3-105'; 12.select avg(degree),cnofrom scorewhere cno like '3%'group by cnohaving count(sno)&= 5; 13.SELECT SNO FROM SCORE GROUP BY SNOHAVING MIN(DEGREE)&70 AND MAX(DEGREE)&90; 14.SELECT A.SNAME,B.CNO,B.DEGREE FROMSTUDENT AS A JOIN SCORE AS B ON A.SNO=B.SNO; 15.SELECT A.CNAME, B.SNO,B.DEGREE FROMCOURSE AS A JOIN SCORE AS B ON A.CNO=B.CNO ; 16.SELECT A.SNAME,B.CNAME,C.DEGREE FROMSTUDENT A JOIN (COURSE B,SCORE C)ON A.SNO=C.SNO AND B.CNO =C.CNO; 17.SELECT AVG(A.DEGREE) FROM SCORE A JOINSTUDENT B ON A.SNO = B.SNO WHERE B.CLASS='95033'; 18.SELECT A.SNO,A.CNO,B.RANK FROM SCOREA,GRADE B WHERE A.DEGREE BETWEEN B.LOW AND B.UPP ORDER BY RANK; 19.SELECT A.* FROM SCORE A JOIN SCORE BWHERE A.CNO='3-105' AND A.DEGREE&B.DEGREE AND B.SNO='109' AND B.CNO='3-105';另一解法：SELECT A.* FROM SCORE A
WHEREA.CNO='3-105' AND A.DEGREE&ALL(SELECT DEGREE FROM SCORE B WHERE B.SNO='109' ANDB.CNO='3-105'); 20.SELECT * FROM score s WHEREDEGREE&(SELECT MAX(DEGREE) FROM SCORE) GROUP BY SNO HAVING COUNT(SNO)&1 ORDER BY DEGREE ; 21.见19的第二种解法 22。SELECTSNO,SNAME,SBIRTHDAY FROM STUDENT WHERE YEAR(SBIRTHDAY)=(SELECT YEAR(SBIRTHDAY) FROM STUDENT WHERE SNO='108');ORACLE:select x.cno,x.Sno,x.degree fromscore x,score y where x.degree&y.degree and y.sno='109'and y.cno='3-105';select cno,sno,degree from score
where degree &(select degree from scorewhere sno='109' and cno='3-105') 23.SELECT A.SNO,A.DEGREE FROM SCORE A JOIN(TEACHER B,COURSE C)ON A.CNO=C.CNO AND B.TNO=C.TNOWHERE B.TNAME='张旭';另一种解法：select cno,sno,degree from score where cno=(select x.cno from coursex,teacher y where x.tno=y.tno and y.tname='张旭');根据实际EXPLAIN此SELECT语句，第一个的扫描次数要小于第二个 24.SELECT A.TNAME FROM TEACHER A JOIN(COURSE B, SCORE C) ON (A.TNO=B.TNO AND B.CNO=C.CNO) GROUP BY C.CNO HAVING COUNT(C.CNO)&5;另一种解法：select tname from teacher where tno in(select x.tno from coursex,score y where x.cno=y.cno group by x.tno havingcount(x.tno)&5);实际测试1明显优于2
25。selectcno,sno,degree from score where cno=(select x.cno from course x,teacher y where x.tno=y.tno and y.tname='张旭'); 26。SELECT CNO FROMSCORE GROUP BY CNO HAVING MAX(DEGREE)&85;另一种解法：select distinct cno from score where degree in (select degree fromscore where degree&85); 27。SELECT A.* FROMSCORE A JOIN (TEACHER B,COURSE C) ON A.CNO=C.CNO AND B.TNO=C.TNOWHERE B.DEPART='计算机系';另一种解法：SELECT * from score where cno in (select a.cno from course a jointeacher b on a.tno=b.tno and b.depart='计算机系');此时2略好于1，在多连接的境况下性能会迅速下降 28。select tname,proffrom teacher where depart='计算机系' and prof not in (select prof from teacher where depart='电子工程系'); 29。SELECT * FROM SCOREWHERE DEGREE&ANY(SELECT DEGREE FROM SCORE WHERE CNO='3-245') ORDER BY DEGREE DESC; 30。SELECT * FROM SCOREWHERE DEGREE&ALL(SELECT DEGREE FROM SCORE WHERE CNO='3-245') ORDER BY DEGREE DESC; 31.SELECT SNAME AS NAME, SSEX AS SEX,SBIRTHDAY AS BIRTHDAY FROM STUDENTUNIONSELECT TNAME AS NAME, TSEX AS SEX,TBIRTHDAY AS BIRTHDAY FROM TEACHER; 32.SELECT SNAME AS NAME, SSEX AS SEX,SBIRTHDAY AS BIRTHDAY FROM STUDENT WHERE SSEX='女'UNIONSELECT TNAME AS NAME, TSEX AS SEX,TBIRTHDAY AS BIRTHDAY FROM TEACHER WHERE TSEX='女'; 33.SELECT A.* FROM SCORE A WHEREDEGREE&(SELECT AVG(DEGREE) FROM SCORE B WHERE A.CNO=B.CNO);须注意********此题 34。解法一：SELECTA.TNAME,A.DEPART FROM TEACHER A JOIN COURSE B ON A.TNO=B.TNO;解法二：select tname,depart from teacher a where exists(select * from course b where a.tno=b.tno);解法三：SELECT TNAME,DEPART FROM TEACHER WHERE TNO IN (SELECT TNO FROMCOURSE); 实际分析，第一种揭发貌似更好，至少扫描次数最少。 35.解法一：SELECTTNAME,DEPART FROM TEACHER A LEFT JOIN COURSE B USING(TNO) WHERE ISNUL (B.tno);解法二：select tname,depart from teacher a where not exists(select * from course b where a.tno=b.tno);解法三：SELECT TNAME,DEPART FROM TEACHER WHERE TNO NOT IN (SELECT TNO FROMCOURSE);NOT IN的方法效率最差，其余两种差不多 36.SELECT CLASS FROM STUDENT A WHERE SSEX='男' GROUP BYCLASS HAVING COUNT(SSEX)&1; 37.SELECT * FROM STUDENT A WHERE SNAME notlike '王%'; 38.SELECTSNAME,(YEAR(NOW())-YEAR(SBIRTHDAY)) AS AGE FROM STUDENT; 39.select sname,sbirthday as THEMAX fromstudent where sbirthday =(select min(SBIRTHDAY) from student)unionselect sname,sbirthday as THEMIN fromstudent where sbirthday =(select max(SBIRTHDAY) from student); 40.SELECTCLASS,(YEAR(NOW())-YEAR(SBIRTHDAY)) AS AGE FROM STUDENT ORDER BY CLASS DESC,AGE DESC; 41.SELECT A.TNAME,B.CNAME FROM TEACHER AJOIN COURSE B USING(TNO) WHERE A.TSEX='男'; 42.SELECT A.* FROM SCORE A WHEREDEGREE=(SELECT MAX(DEGREE) FROM SCORE B ); 43.SELECT SNAME FROM STUDENT A WHERESSEX=(SELECT SSEX FROM STUDENT B WHERE B.SNAME='李军'); 44.SELECT SNAME FROM STUDENT A WHERESSEX=(SELECT SSEX FROM STUDENT B WHERE B.SNAME='李军' )AND CLASS=(SELECT CLASS FROM STUDENT CWHERE c.SNAME='李军'); 45.解法一：SELECT A.* FROMSCORE A JOIN (STUDENT B,COURSE C) USING(sno,CNO) WHERE B.SSEX='男 ' AND C.CNAME='计算机导论';解法二：select * from score where sno in(select sno from student wheressex='男') and cno=(selectcno from coursewhere cname='计算机导论');
贝尔教育是211,985高校专/本科学历,正规学历教育招生机构,名师授课,学习便捷!贝尔教育18年专注于上班族在职工作人员的学历提升 职业技能培训,资格认证等,详情点击
吧主把你创建语句没个单词对应什么分享一下
登录百度帐号推荐应用当前位置： &nbsp > &nbsp&nbsp >&nbsp正文
class&&&&&&&&&&& 这些名词均有&级，等级&之意。
______________________________________________________________
grade: 指按地位或优劣划分的等级，既可指人又可指物。
class: 含义广泛，指人或物按优劣划分的等级，也指学校中的年级或班级。
degree: 指程度、范围不同，社会地位的高低。也可指形容词或副词的级。
rank: 指人在社会中的地位或等级，尤指军队中的军衔。
市场合作联系
联系人靳华
E-mailjinhua#wps.cn
jinhua#kingsoft.com
广告合作联系
联系人蔡先生From Wikipedia, the free encyclopedia
The 2016 AFC Cup was the 13th edition of the , 's secondary club
tournament organized by the
to win their first AFC Cup title, becoming the first Iraqi team to win the competition.
were the defending champions, but were eliminated in the semi-finals by .
The AFC Competitions Committee proposed a revamp of the AFC club competitions on 25 January 2014, which was ratified by the AFC Executive Committee on 16 April 2014. The 46
member associations (excluding the associate member ) are ranked based on their national team's and clubs' performance over the last four years in AFC competitions, with the allocation of slots for the 2015 and 2016 editions of the AFC club competitions determined by the 2014 rankings:
The associations are split into West Zone and East Zone, with 23 associations in each zone:
West Zone consists of the associations from , , , except India and Maldives
East Zone consists of the associations from
and , plus India and Maldives
In each zone, there are a total of 12 direct slots in the group stage, with the 4 remaining slots filled through play-offs.
All associations which do not receive direct slots in the AFC Champions League group stage are eligible to enter the AFC Cup.
The associations ranked 7th to 16th in each zone get at least one direct slot in the group stage (including losers of the AFC Champions League qualifying play-off), while the remaining associations get only play-off slots:
The associations ranked 7th and 8th each get two direct slots.
The associations ranked 9th to 12th each get one direct slot and one play-off slot (in play-off round).
The associations ranked 13th to 16th each get one direct slot and one play-off slot (in preliminary round).
The associations ranked 17th or below each get one play-off slot (in qualifying round).
The AFC Competitions Committee decided on the participation of member associations in the 2015 and 2016 editions of the AFC Cup on 28 November 2014.
The following table shows the slot allocation for the 2016 AFC Cup, which are adjusted accordingly since some of the slots are unused.
Participation for 2016 AFC Cup
Participating
Not participating
Association
Association
Iraq were given special permission to participate in the AFC Cup, since they were not allowed to participate in the AFC Champions League as none of their teams passed the club licensing requirements.
Kuwait were allocated one AFC Champions League play-off slot and one group stage slot, but could not participate due to FIFA's suspension of its football association.
Oman were not allowed to participate in the AFC Champions League as none of their teams passed the club licensing requirements, so their champions directly entered the AFC Cup group stage. They also had their second team directly entering the group stage instead of the play-off round due to unused slots.
Bahrain, Lebanon and Syria were not allowed to participate in the AFC Champions League as none of their teams passed the club licensing requirements, so their champions directly entered the AFC Cup group stage.
Palestine, Tajikistan and Turkmenistan all had their second team entering the play-off round instead of the preliminary round due to unused slots.
Afghanistan were allocated one group stage slot and one preliminary round slot, but did not enter a team.
Kyrgyzstan were originally allocated one qualifying round slot, but were given an additional play-off round slot.
Yemen, Sri Lanka and Nepal were allocated one qualifying round slot, but did not enter a team.
Indonesia were allocated one AFC Champions League play-off slot and one group stage slot, but could not participate due to FIFA's suspension of its football association.
Myanmar, Malaysia, India and Singapore all had their second team directly entering the group stage instead of the play-off round due to unused slots.
Maldives and Philippines both had their second team directly entering the group stage instead of the preliminary round due to unused slots.
North Korea were allocated one group stage slot and one preliminary round slot, but did not enter a team.
Laos were allocated one group stage slot and one preliminary round slot, but entered only one team as
is the only team in Laos eligible to play in AFC Cup.
Guam, East Timor, Cambodia, Chinese Taipei and Brunei were allocated one qualifying round slot, but did not enter a team.
Bangladesh was originally in the West Zone, but was moved to the East Zone due to lack of teams in the East Zone.
The following 40 teams from 23 associations entered the competition.
Qualifying method
direct entrants (Groups A–D)
runners-up
runners-up
Entering in
(play-off round)
runners-up
runners-up
Qualifying method
direct entrants (Groups E–H)
runners-up
runners-up
Qualifying method
Entering in
(teams not split into zones for qualifying round)
AFC Champions League (ACL): Teams played in the , but failed to advance to the AFC Champions League group stage (had they advanced to the AFC Champions League group stage, they would have been replaced in the AFC Cup group stage by another team from the same association).
Malaysia (MAS): Since , the
winners, is a team managed by the
and thus ineligible to represent Malaysia in AFC club competitions, their place was taken by , the
runners-up.
Singapore (SIN): Since , the
champions, is a team managed by the
and thus ineligible to represent Singapore in AFC club competitions, their place was taken by , the league runners-up. Moreover, since , the
winners and league 3rd place, is a satellite team of Japanese club
and thus ineligible to represent Singapore in AFC club competitions, their place was taken by , the league 4th place.
Teams from Jordan:
Teams from Lebanon:
Teams from Syria:
Teams from Palestine:
Location of teams of the 2016 AFC Cup.
(p) Qualifying play-off participants
(q) Qualifying round participants
The schedule of the competition was as follows (all draws are held in , ).
Second leg
Qualifying stage
Qualifying round
29 June 2015
11–15 August 2015
Play-off stage
Play-off round
9 February 2016
Group stage
Matchday 1
10 December 2015
23–24 February 2016
Matchday 2
8–9 March 2016
Matchday 3
15–16 March 2016
Matchday 4
12–13 April 2016
Matchday 5
26–27 April 2016
Matchday 6
10–11 May 2016
Knockout stage
Round of 16
24–25 May 2016
Quarter-finals
9 June 2016
13–14 September 2016
20–21 September 2016
Semi-finals
27–28 September 2016
18–19 October 2016
5 November 2016
The draw for the qualifying round was held on 29 June 2015 at the AFC House in , . The six teams were drawn into two groups of three.
In the qualifying round, each group was played on a single round-robin basis at the pre-selected hosts. The winners of each group advanced to either the
(depending on number of teams in each zone and geographical location).
Qualification
Qualification
Sheikh Jamal Dhanmondi advanced directly to the group stage due to lack of teams in the East Zone.
In the qualifying play-off, each tie was played as a single match.
were used to decide the winner if necessary (Regulations Article 10.2). The four winners of the play-off round advanced to the
to join the 28 direct entrants.
The bracket of the qualifying play-off was determined by the AFC based on the association ranking of each team, with the team from the higher-ranked association hosting each match.
 Score 
The draw for the group stage was held on 10 December
(), at the Petaling Jaya Hilton Hotel in , . The 32 teams were drawn into eight groups of four. Teams from the same association could not be drawn into the same group.
In the group stage, each group was played on a home-and-away
basis. The winners and runners-up of each group advanced to the .
Tiebreakers
The teams were ranked according to
(3 points for a win, 1 point for a draw, 0 points for a loss). If tied on points, tiebreakers would be applied in the following order (Regulations Article 11.5):
Greater number of points obtained in the group matches between
resulting from the group matches between
Greater number of goals scored in the group matches between
Greater number of
scored in the group matches between
If, after applying criteria 1 to 4, teams still have an equal ranking, criteria 1 to 4 are reapplied exclusively to the matches between the teams in question to determine their final rankings. If this procedure does not lead to a decision, criteria 6 to 10
Goal difference in a
Greater number of goals scored in a
if only two teams are involved and they are both
Fewer score calculated according to the number of yellow and red cards received in the group matches (1 point for a single yellow card, 3 points for a red card as a consequence of two yellow cards, 3 points for a direct red card, 4 points for a yellow card followed by a direct red card);
Team who belongs to the member association with the higher AFC ranking.
Qualification
Qualification
Qualification
The Al-Wahda v Shabab Al-Dhahiriya match on matchday 2 (9 March 2016) was not played as scheduled. It was awarded 3–0 to Al-Wahda by the AFC Disciplinary Committee on 28 April 2016, as it found Shabab Al-Dhahiriya as the relevant party for causing the cancellation of the match. The decision was reversed and awarded 3–0 to Shabab Al-Dhahiriya by the AFC Appeal Committee on 24 June 2016, as it found Al-Wahda as the relevant party for causing the cancellation of the match.
The Shabab Al-Dhahiriya v Al-Wahda match on matchday 6 (11 May 2016) was not played as scheduled. It was awarded 3–0 to Al-Wahda by the AFC Disciplinary Committee on 13 May 2016, as it found Shabab Al-Dhahiriya as the relevant party for causing the cancellation of the match.
Qualification
The Ahli Al-Khaleel v Al-Jaish match on matchday 2 (9 March 2016) was delayed to 3 or 4 May 2016, but was not played as scheduled. It was awarded 3–0 to Al-Jaish by the AFC Disciplinary Committee on 13 May 2016, as it found Ahli Al-Khaleel as the relevant party for causing the cancellation of the match.
Qualification
Qualification
Qualification
Qualification
In the knockout stage, the 16 teams played a , with the teams split between the two zones until the final. In the quarter-finals and semi-finals, each tie was played on a home-and-away
basis, while in the round of 16 and final, each tie was played as a single match. The
(for two-legged ties),
(away goals would not apply in extra time) and
were used to decide the winner if necessary (Regulations Article 12.4).
Starting from this season, the knockout stage was split between the two zones until the final, similar to the AFC Champions League (Regulations Article 12.3).
In the round of 16, the winners of one group played the runners-up of another group from the same zone, with the group winners hosting the match.
 Score 
In the quarter-finals, the four teams from the West Zone were drawn into two ties, and the four teams from the East Zone were drawn into the other two ties, with the order of legs also decided by the draw.
The draw for the quarter-finals was held on 9 June
(), at the Petaling Jaya Hilton Hotel in , . There was no seeding or country protection, so teams from the same association could be drawn into the same tie.
In the semi-finals, the two quarter-final winners from the West Zone played each other, and the two quarter-final winners from the East Zone played each other, with the order of legs determined by the quarter-final draw.
In the final, the two semi-final winners played each other, with the host team decided by a draw, held after the quarter-final draw.
5 November 2016)
19:00 
Attendance: 5,806
AFC Cup 2016
First Title
Most Valuable Player
Top Goalscorer
Fair Play Award
Note: Goals scored in the qualifying play-off are not counted when determining top scorer (see regulations, Article 77.4).
Source: the-AFC.com
(PDF). AFC. 28 November 2015.
. AFC. 5 November .
. AFC. 25 January 2014.
. AFC. 16 April 2014.
(PDF). AFC.
. AFC. 28 November 2014.
. AFC. 4 December 2014.
(PDF). AFC.
. AFC. 4 December 2015.
. AFC. 29 June 2015.
(PDF). AFC.
(PDF). AFC.
. AFC. 8 June 2016.
. AFC. 10 December 2015.
(PDF). AFC.
. AFC. 29 April 2016.
(PDF). AFC. 28 April 2016.
. AFC. 24 June 2016.
(PDF). AFC. 24 June 2016.
. AFC. 13 May 2016.
(PDF). AFC. 13 May 2016.
. AFC. 9 June 2016.
. AFC. 5 November .
. Goal. 6 November .
. the-afc.com. AFC.
. the-afc.com. AFC.
. the-afc.com. AFC.
, the-AFC.com}