Postgres 14

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

select version();


version


PostgreSQL 14.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-4), 64-bit


CREATE TABLE table_first (
   a VARCHAR(20),
   created_at timestamp,
   b INTEGER,
   c INTEGER);
INSERT INTO table_first VALUES
  ('LK0601','2022-03-01 10:00:00',1,1),
  ('LK0601','2022-03-02 10:00:00',1,2),
  ('LK0601','2022-03-03 10:00:00',1,3),

  ('DT9834','2022-03-01 10:00:00',2,1),
  ('DT9834','2022-03-02 10:00:00',2,2),
  ('DT9834','2022-03-03 10:00:00',2,3),

  ('LM3526','2022-03-01 10:00:00',3,1),
  ('LM3526','2022-03-02 10:00:00',3,2),
  ('LM3526','2022-03-03 10:00:00',3,3)
  ;
9 rows affected

(SELECT a, created_at time, b, c 
FROM table_first 
WHERE created_at >= timestamp '2022-02-13 00:00:00' AND a = 'LK0601' 
ORDER BY time desc limit 1)

UNION

(SELECT a, created_at time, b, c 
FROM table_first 
WHERE created_at >= timestamp '2022-02-13 00:00:00' AND a = 'DT9834' 
ORDER BY time desc limit 1)

UNION

(SELECT a, created_at time, b, c 
FROM table_first 
WHERE created_at >= timestamp '2022-02-13 00:00:00' AND a = 'LM3526' 
ORDER BY time desc limit 1);


a
time
b
c


LK0601
2022-03-03 10:00:00
1
3

LM3526
2022-03-03 10:00:00
3
3

DT9834
2022-03-03 10:00:00
2
3

a	time	b	c
LK0601	2022-03-03 10:00:00	1	3
LM3526	2022-03-03 10:00:00	3	3
DT9834	2022-03-03 10:00:00	2	3