如何删除不正确的语法错误

本文介绍了如何删除不正确的语法错误的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

下面我在尝试区分值时给出SQL代码然后我得到语法错误所以请帮助我

我尝试过：

Below i Give Code of SQL When I Try to Distinct Value Then i Get Syntax Error So Please Help Me

What I have tried:

SELECT distinct * FROM (
select  Tbl_Faculty.First_Name,Designation_Master.Designation_Description,Tbl_Course_Master.Course_Name,

      Tbl_Specialisation_Master.Specialisation_Name,FacultyQualification.PassingYr,
	  Tbl_Faculty.Date_Of_Birth

 from Tbl_Faculty inner join FacultyQualification on Tbl_Faculty.Faculty_Id=FacultyQualification.FacultyId
inner join Tbl_Course_Master on FacultyQualification.CourseId=Tbl_Course_Master.Course_Id
Inner Join Tbl_Specialisation_Master on Tbl_Specialisation_Master.Course_Id=FacultyQualification.CourseId
inner Join Designation_Master on Designation_Master.DesignationID=Tbl_Faculty.Designation_Id
  where Tbl_Faculty.College_Id='406' and Availabilty_Flag= 'N'

推荐答案

where Tbl_Faculty.College_Id='406' and Availabilty_Flag= 'N' )

SELECT distinct * FROM (
 select Tbl_Faculty.First_Name,Designation_Master.Designation_Description,Tbl_Course_Master.Course_Name,

 Tbl_Specialisation_Master.Specialisation_Name,FacultyQualification.PassingYr,
 Tbl_Faculty.Date_Of_Birth

 from Tbl_Faculty inner join FacultyQualification on Tbl_Faculty.Faculty_Id=FacultyQualification.FacultyId
 inner join Tbl_Course_Master on FacultyQualification.CourseId=Tbl_Course_Master.Course_Id
 Inner Join Tbl_Specialisation_Master on Tbl_Specialisation_Master.Course_Id=FacultyQualification.CourseId
 inner Join Designation_Master on Designation_Master.DesignationID=Tbl_Faculty.Designation_Id
 where Tbl_Faculty.College_Id='406' and Availabilty_Flag= 'N')

这篇关于如何删除不正确的语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！