By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table RV_USERS (UserID int, Audit_Date date);
insert into RV_USERS values (1, '10/29/2019')
insert into RV_USERS values (2, '10/28/2019')
insert into RV_USERS values (3, '09/27/2019')
insert into RV_USERS values (4, '06/20/2019')
insert into RV_USERS values (5, '04/10/2019')
insert into RV_USERS values (5, '11/10/2019')
6 rows affected
SELECT * FROM RV_USERS WHERE UserID in (UserID, 2)
UserID | Audit_Date |
---|---|
1 | 29/10/2019 00:00:00 |
2 | 28/10/2019 00:00:00 |
3 | 27/09/2019 00:00:00 |
4 | 20/06/2019 00:00:00 |
5 | 10/04/2019 00:00:00 |
5 | 10/11/2019 00:00:00 |