A.主鍵的值對(duì)用戶而言是沒有什么意義 B.主鍵的主要作用是將記錄和存放在其他表中的數(shù)據(jù)進(jìn)行關(guān)聯(lián)。 C.一個(gè)主鍵是唯一識(shí)別一個(gè)表的每一記錄, D.主鍵是不同表中各記錄之間的簡(jiǎn)單指針。
A.DATE B.INT C.CHAR D.TEXT
A.SELECT rank,AVG(salary)FROM people GROUP BY rank HAVING AVG(salary)>1000 B.SELECT rank,AVG(salary)FROM people HAVING AVG(salary)>1000 GROUP BY rank; C.SELECT AVG(salary)FROM people GROUP BY rank HAVING AVG(salary)>1000; D.SELECT rank,AVG(salary)FROM people GROUP BY rank WHERE AVG(salary)>1000;