SQL 内部函数和内联函数 有什么区别 请高手耐心 分析解答一下

[liqiexingxing]

--查学生学号、姓名、考试科目名称及成绩
select A.StudentNo as 学号,
A.StudentName as 姓名,
count(B.SubjectName) as 科目名称 ,
C.StudentResult as 成绩
from Student as A ,Subject as B,Result as C
group by A.StudentNo ,A.StudentName ,C.StudentResult


select A.StudentNo as 学号,
A.StudentName as 姓名,
COUNT(B.SubjectName) as 考试科目名称,
C.StudentResult as 成绩分数
from Student as A
inner join Subject as B on B.GradeId=A.GradeId
inner join Result as C on C.StudentNo=A.StudentNo
group by A.StudentNo ,A.StudentName ,C.StudentResult



这样对吗？？

[liqiexingxing]

那这二个方法 哪一个是对的呢？？？？？？

[以专业开发人员为伍]

内部函数就是系统自带的、你不能重写的函数。内联函数就是返回数据集合的函数。两个根本不可比。