[主观题]

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.

参考答案与解析：

相关试题

9. Two__________ students in our school: [单选题]9． Two__________ students in our school will go to the beach for holiday．A．hundredB．hundreds ．C． hundred ofD． hundrAeds of

查看答案

Two ______teachers and four ______students were praised at the meeting yesterday．（）: Two ______teachers and four ______students were praised at the meeting yesterday

查看答案

The teacher agreed to the suggestion that the students ________ two weeks to prepare for the exam.: The teacher agreed to the suggestion that the students ________ two weeks to pre

查看答案

What did the two students emphasize to the group after reaching the mountain top?: What did the two students emphasize to the group after reaching the mountain top

查看答案

The pen writes smoothly 2 . The teacher with two of his students ( is walking into the classroom: The pen writes smoothly 2 . The teacher with two of his students ( is walking in

查看答案

Two_and four girl students were praised at the meeting yesterday.: Two_and four girl students were praised at the meeting yesterday.A. women teache

查看答案

These two students from our school have been admitted to Beijing University.: [问答题]These two students from our school have been admitted to Beijing University

查看答案

1.The teacher had to _ when two students were arguing in class.: 1.The teacher had to _ when two students were arguing in class.A. breedB. deserv

查看答案

SCOR模型包括：（）。: [多选题] SCOR模型包括：（）。A . 供应链流程的性能指标基准B . 供应链最佳实施的描述C . 确定供应链核心企业的条件D . 选择供应链软件产品的信息

查看答案

39.英文版《太阳方位表》是( )。 ① Davis's Tables;② Burdwood's Tables;③Azimuth Tables。( ): 39.英文版《太阳方位表》是( )。 ① Daviss Tables;② Burdwoods Tables;③Azimuth Tables。( )A. ①②B.

查看答案