解决方案 »
- 我想要同时更新两个表的两个字段 应该怎么写?
- VC通过ADO连接mysql数据库提示错误
- 求sql语句..
- 删除大表发现速度过慢
- 如何让mysql结束一个对五千万条记录的查询
- mysql编码问题
- 请教在bin下执行./mysqldump -u someone -p db < db.sql和./mysql -u someone -p db < db.sql的区别
- SQL Server附加的Visual Studio 2005没有编程语言,怎么办?
- 请教高手!Fedora 5 用C call MySQL 出现 Lost connection to MySQL Server during query 什么原因?
- 怎么把VFP的数据库表导入到MySQL中.(送100分)在线等
- 请教linux下mysql 存储过程的报错问题
- 一个简单的mysql语句,求解?
mysql> select a.* From score A join (
-> SELECT cno,sum(degree)/count(*) as Avg
-> FROM score Group by cno )B on A.cno=B.cno
-> order by b.avg,a.degree;
+-----+-------+--------+
| SNO | CNO | DEGREE |
+-----+-------+--------+
| 109 | 3-245 | 68.0 |
| 105 | 3-245 | 75.0 |
| 103 | 3-245 | 86.0 |
| 107 | 6-106 | 79.0 |
| 101 | 3-105 | 64.0 |
| 109 | 3-105 | 76.0 |
| 108 | 3-105 | 78.0 |
| 105 | 3-105 | 88.0 |
| 107 | 3-105 | 91.0 |
| 103 | 3-105 | 92.0 |
| 108 | 6-166 | 81.0 |
| 101 | 6-166 | 85.0 |
+-----+-------+--------+
12 rows in set (0.00 sec)mysql>