81,090
社区成员
发帖
与我相关
我的任务
分享
select student.StudentName as studentname,student.StudentId as studentid,student.MatriNo as matrino,speciality.SpecialityName as specialityname from student,speciality where student.SpecialityId=speciality.SpecialityId and student.SpecialityId=? and student.StudentName like ? limit 3 order by StudentId desc