计算排名的函数不会是哪个?
A: rank
B: rank.eq
C: rand
D: rank.avg
A: rank
B: rank.eq
C: rand
D: rank.avg
举一反三
- 计算总分需要用到的函数是?计算排名需要用到的函数是? A: sumif函数，rand函数 B: sum函数，rand函数 C: sumif函数，rank函数 D: sum函数，rank函数
- 下列函数，排名函数是（） A: RAND B: RATE C: SUMIF D: RANK
- 排名函数的函数名是下列哪个选项? A: rand B: rank C: RANT D: rant
- 以下语句错误的是() A: LECT rank, AVG(salary) FROM people HAVING AVG(salary) > 1000 GROUP BY rank; B: SELECT rank, AVG(salary) FROM people GROUP BY rank HAVING AVG(salary) > 1000 C: SELECT rank, AVG(salary) FROM people HAVING AVG(salary) > 1000 GROUP BY rank; D: SELECT AVG(salary) FROM people GROUP BY rank HAVING AVG(salary) > 1000; E: SELECT rank, AVG(salary) FROM people GROUP BY rank WHERE AVG(salary) > 1000;
- 下列哪个函数可以实现排名计算 A: sum B: average C: if D: rank