SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Table1
    ([id] int, [OtherId] varchar(1), [createdAt] datetime)
;
    
INSERT INTO Table1
    ([id], [OtherId], [createdAt])
VALUES
    (1, 'A', '2019-11-28 05:03:01'),
    (2, 'A', '2019-11-28 05:03:02'),
    (3, 'A', '2019-11-28 05:03:03'),
    (4, 'A', '2019-11-28 05:03:04'),
    (5, 'A', '2019-11-28 05:03:05'),
    (6, 'A', '2019-11-28 05:03:06'),
    (7, 'A', '2019-11-28 05:03:07'),
    (8, 'A', '2019-11-28 05:03:08'),
    (11, 'B', '2019-11-28 05:03:11'),
    (12, 'B', '2019-11-28 05:03:12'),
    (13, 'B', '2019-11-28 05:03:13'),
    (14, 'B', '2019-11-28 05:03:14'),
    (15, 'B', '2019-11-28 05:03:15'),
    (16, 'B', '2019-11-28 05:03:16')
;
14 rows affected

SELECT
  id
  , createdAt
FROM (
  SELECT
    id
    , createdAt
    , RANK() OVER (PARTITION BY OtherId ORDER BY createdAt) rnk
  FROM Table1
  where OtherId='A'
) AS S
WHERE rnk = 8
;


id
createdAt


8
28/11/2019 05:03:08


WITH
S (id, createdAt, rnk) AS (
  SELECT
    id
    , createdAt
    , RANK() OVER (PARTITION BY OtherId ORDER BY createdAt) rnk
  FROM Table1
   where OtherId='A'
)
SELECT
  id
  , createdAt
FROM S
WHERE rnk = 8
;


id
createdAt


8
28/11/2019 05:03:08


SELECT
    id
    , createdAt
    , RANK() OVER (PARTITION BY OtherId ORDER BY createdAt) rnk
  FROM Table1
  where OtherId='A'


id
createdAt
rnk


1
28/11/2019 05:03:01
1

2
28/11/2019 05:03:02
2

3
28/11/2019 05:03:03
3

4
28/11/2019 05:03:04
4

5
28/11/2019 05:03:05
5

6
28/11/2019 05:03:06
6

7
28/11/2019 05:03:07
7

8
28/11/2019 05:03:08
8

id	createdAt	rnk
1	28/11/2019 05:03:01	1
2	28/11/2019 05:03:02	2
3	28/11/2019 05:03:03	3
4	28/11/2019 05:03:04	4
5	28/11/2019 05:03:05	5
6	28/11/2019 05:03:06	6
7	28/11/2019 05:03:07	7
8	28/11/2019 05:03:08	8