MSSQL multiple select statements with except
To give it a try, run the following script:
1 2 3 4 | USE BookStore SELECT id, name, category, price FROM Books1 Except SELECT id, name, category, price FROM Books2 |
Here is the output of the above script:
Time Example
SELECT distinct td.[CandidateID] ,pc.Description AS Province ,Year(td.Start) ,Day(td.Start) ,cast(td.[Start] as time) [time] ,cast(td.[End] as time) [time] FROM [hjklhj].[dbo].[TimesheetDetail] AS td INNER JOIN [jkljkh].[dbo].[Candidate] AS cd on td.CandidateID = cd.CandidateID INNER JOIN [hjlhhhj].[dbo].[Province] AS pc on cd.ProvinceID = pc.Id WHERE pc.Description = 'CB070000-CPT' AND Year(Start) = '2021' AND Month(Start) = '01'
Comments
Post a Comment