SQL Server 2017

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

CREATE TABLE [dbo].[Books](
    [ID] [nchar](10) NOT NULL,
    [AUTHCODE] [nchar](10) NULL,
    [TITLE] [nchar](10) NULL
) ON [PRIMARY];

INSERT [dbo].[Books] ([ID], [AUTHCODE], [TITLE]) VALUES (N'1', N'nk', N'Book1');

INSERT [dbo].[Books] ([ID], [AUTHCODE], [TITLE]) VALUES (N'2', N'an', N'Book2');

INSERT [dbo].[Books] ([ID], [AUTHCODE], [TITLE]) VALUES (N'3', N'mn', N'Book3');

INSERT [dbo].[Books] ([ID], [AUTHCODE], [TITLE]) VALUES (N'4', N'ra', N'Book4');

INSERT [dbo].[Books] ([ID], [AUTHCODE], [TITLE]) VALUES (N'5', N'kd', N'Book5');

INSERT [dbo].[Books] ([ID], [AUTHCODE], [TITLE]) VALUES (N'6', N'nk', N'Book6');

INSERT [dbo].[Books] ([ID], [AUTHCODE], [TITLE]) VALUES (N'7', N'an', N'Book7');

INSERT [dbo].[Books] ([ID], [AUTHCODE], [TITLE]) VALUES (N'8', N'ra', N'Book8');

INSERT [dbo].[Books] ([ID], [AUTHCODE], [TITLE]) VALUES (N'9', N'kd', N'Book9');

INSERT [dbo].[Books] ([ID], [AUTHCODE], [TITLE]) VALUES (N'10', N'mn', N'Book10');

DECLARE @List1 AS TABLE (ID INT);

INSERT INTO @List1 
SELECT 2 UNION SELECT 4 UNION SELECT 6 UNION
SELECT 7 UNION SELECT 8 UNION SELECT 9;

SELECT *
FROM Books
WHERE ID IN (SELECT ID FROM @List1);

DECLARE @List2 As TABLE (AFrom INT, ATo INT);

INSERT INTO @List2
SELECT 2, 4 UNION SELECT 7, 9;

SELECT *
FROM Books B CROSS APPLY @List2 L
WHERE B.ID BETWEEN L.AFrom AND L.ATo;

ID	AUTHCODE	TITLE	AFrom	ATo
2	an	Book2	2	4
3	mn	Book3	2	4
4	ra	Book4	2	4
7	an	Book7	7	9
8	ra	Book8	7	9
9	kd	Book9	7	9