Except Keyword SQL Server - SQl Server Except

 Select top (select COUNT(*) from CourtApplicationDetails) * From CourtApplicationDetails

EXCEPT

Select top ((select COUNT(*) from CourtApplicationDetails)-(1)) * From CourtApplicationDetails

ref:- https://github.com/jaygajera17/Tour_Management_Asp.Net/blob/main/DotNetFrameworkProject_CE040_CE087/Tour_Management/usercrud.aspx