P4dEDHjv

1SELECT MAX(Revision)
2FROM dbo.TheOneders
3WHERE Id = 1 AND 1 = (SELECT 1);
4	
5SELECT MAX(Revision)
6FROM dbo.TheOneders
7WHERE Id = 1
8GROUP BY Id;
9	
10DROP TABLE IF EXISTS dbo.TheOneders;
11GO
12
13CREATE TABLE dbo.TheOneders
14(
15    Id INT NOT NULL,
16    Revision SMALLINT NOT NULL,
17    Something NVARCHAR(23),
18
19    CONSTRAINT PK_TheOneders PRIMARY KEY NONCLUSTERED (Id, Revision)
20);
21GO
22
23INSERT INTO dbo.TheOneders
24    (Id, Revision, Something)
25SELECT DISTINCT TOP 1000 
26    1, m.message_id, 'Do...'
27FROM sys.messages m
28ORDER BY m.message_id
29OPTION (MAXDOP 1);
30
31INSERT INTO dbo.TheOneders
32    (Id, Revision, Something)
33SELECT DISTINCT TOP 100 
34    2, m.message_id, 'Do that thing you do...'
35FROM sys.messages m
36ORDER BY m.message_id
37OPTION (MAXDOP 1);
38GO