问题详情

答题翼 > 问答 > 求职面试 > 正文
目录: 标题| 题干| 答案| 搜索| 相关

There are two tables: students, and scores, in the mysql database (4.0+) exactly like t


There are two tables: students, and scores, in the mysql database (4.0+) exactly like this:

SN | Name SN | Score

------------- -------------

1 | Jerry 1 | 48

------------- -------------

2 | Lily 2 | 50

------------- -------------

3 | Roy

-------------

where the SN is the foreigh key. Write an SQL statement to delete all the names that have no score.

请帮忙给出正确答案和分析,谢谢!

参考答案
答案整理中……
您可能感兴趣的试题