Question

写出查询xsxx.dbf中学号、姓名的sql命令

Answer 1

select [中学号],[姓名] from xsxx.dbf

Answer 2

SELECT XS.学号,姓名,课程号,成绩
FROM XS JOIN CJ ON XS.学号=CJ.学号
order by 1,4 desc