SQL及xbase命令!!

Question

用SQL語句命令
1.用嵌套查詢,顯示出得分大於20的記錄NAME,BIRTH,SCORE

用xbase命令
1.關閉所有標籤,找出人名為May記錄(有兩個),並將每個記錄顯示出來

Answer 1

SELECT name, birth, score
WHERE score>20
ORDER BY name;

GO TOP
DO WHILE !EOF()
IF name="May" THEN
? name, birth, score, phone, address
ENDIF
NEXT
END DO