1.å¦å¾ï¼è¿ä¸ªè¯¾ç¨è¡¨ç¨htmlå¦ä½å代ç
2.学生—课程”数据库中包含学生表、课表课表课程表、源码源码九游源码库学生选课表3个表
å¦å¾ï¼è¿ä¸ªè¯¾ç¨è¡¨ç¨htmlå¦ä½å代ç
è¿ä¸ªä¸»è¦å°±æ¯è¡¨æ ¼ï¼<!DOCTYPE html><html lang="en">
<head>
<meta charset="UTF-8">
<title>课ç¨è¡¨</title>
<style>
h3{ text-align:center;width:px;}
table{ border-collapse:collapse;width:px;}
th,网站python mysqldb 源码td{ border:1px solid #;}
</style>
</head>
<body>
<h3>课ç¨è¡¨</h3>
<table>
<thead>
<tr>
<th colspan="2"></th>
<th>ææä¸</th>
<th>ææäº</th>
<th>ææä¸</th>
<th>ææå</th>
<th>ææäº</th>
</tr>
</thead>
<tbody>
<tr>
<td rowspan="2">ä¸å</td>
<td>1</td>
<td>è¯æ</td>
<td>æ°å¦</td>
<td>ç©ç</td>
<td>åå¦</td>
<td>çç©</td>
</tr>
<tr>
<td>2</td>
<td>ä½è²</td>
<td>é³ä¹</td>
<td>å ä½</td>
<td>ç»ç»</td>
<td>èè¹</td>
</tr>
<tr>
<td rowspan="2">ä¸å</td>
<td>1</td>
<td>ä½è²</td>
<td>ç»ç»</td>
<td>é³ä¹</td>
<td>è¯æ</td>
<td>é³ä¹</td>
</tr>
<tr>
<td>2</td>
<td>é³ä¹</td>
<td>è¯æ</td>
<td>ä½è²</td>
<td>å±æ</td>
<td>ä½è²</td>
</tr>
</tbody>
</table>
</body>
</html>
学生—课程”数据库中包含学生表、课程表、课表课表php im源码学生选课表3个表
您好,源码源码黑色线源码这样:
--1
select Sname,网站oa源码jspSage from Student where Sage<(select Sage from Student where Sno='某一学生') and Sdept='数学系'
--2
select Sname from Student where Sno in (select Sno from SC)
--3
select Sname from Student where Sno in (select Sno from SC group by Sno having count(*)=(select count(*) from Course ))
--4
题意不清楚。
课表课表