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

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.

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

参考答案
答案整理中……
您可能感兴趣的试题
  • There are two tables: students, and scores, in the mysql database (4.0+) exactly like t

  • There are some oranges on the table.(英译中)

  • There are five apples on the table.(英译中)

  • Look! There are______grazing over there.A.two cattiesB.two head of cattiesC.two cattleD.tw

  • There are two _______ students on the play ground

  • Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:Which two statements are true about redefining the table?()