Table script -
CREATE TABLE [dbo].[tblEmployee](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](50) NULL,
[Email] [varchar](50) NULL,
[Password] [varchar](50) NULL,
[Mobile] [varchar](15) NULL,
[Salary] [numeric](18, 2) NULL,
[DOJ] [date] NOT NULL CONSTRAINT [DF_tblEmployee_DOJ] DEFAULT (getdate()),
CONSTRAINT [PK_tblEmployee] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[tblEmployee] ON
GO
INSERT [dbo].[tblEmployee] ([Id], [Name], [Email], [Password], [Mobile], [Salary], [DOJ]) VALUES (1, N'Sunil', N'sk@gmail.com', N'12345678', N'989898989', CAST(50000.00 AS Numeric(18, 2)), CAST(N'2022-01-31' AS Date))
GO
INSERT [dbo].[tblEmployee] ([Id], [Name], [Email], [Password], [Mobile], [Salary], [DOJ]) VALUES (2, N'Anil', N'anil@gmail.com', N'4534534', N'987977867', CAST(40000.00 AS Numeric(18, 2)), CAST(N'2022-01-28' AS Date))
GO
INSERT [dbo].[tblEmployee] ([Id], [Name], [Email], [Password], [Mobile], [Salary], [DOJ]) VALUES (3, N'Anil', N'ak@gmail.com', N'565ef44', N'986858576', CAST(85000.00 AS Numeric(18, 2)), CAST(N'2022-02-25' AS Date))
GO
INSERT [dbo].[tblEmployee] ([Id], [Name], [Email], [Password], [Mobile], [Salary], [DOJ]) VALUES (4, N'Sunil', N'sunil@gmail.com', N'5345', N'8995675656', CAST(55000.00 AS Numeric(18, 2)), CAST(N'2022-02-28' AS Date))
GO
INSERT [dbo].[tblEmployee] ([Id], [Name], [Email], [Password], [Mobile], [Salary], [DOJ]) VALUES (5, N'Anurag', N'ag@gmail.com', N'76864554', N'789987987', CAST(60000.00 AS Numeric(18, 2)), CAST(N'2022-03-31' AS Date))
GO
INSERT [dbo].[tblEmployee] ([Id], [Name], [Email], [Password], [Mobile], [Salary], [DOJ]) VALUES (6, N'Sony', N'sony@gmail.com', N'576576', N'979787777', CAST(45000.00 AS Numeric(18, 2)), CAST(N'2022-04-10' AS Date))
GO
INSERT [dbo].[tblEmployee] ([Id], [Name], [Email], [Password], [Mobile], [Salary], [DOJ]) VALUES (7, N'Ram', N'ram@gmail.com', N'5345344', N'897897788', CAST(55000.00 AS Numeric(18, 2)), CAST(N'2022-04-30' AS Date))
GO
INSERT [dbo].[tblEmployee] ([Id], [Name], [Email], [Password], [Mobile], [Salary], [DOJ]) VALUES (8, N'Ram', N'ram@hgh.dks', N'546446', N'797899877', CAST(35000.00 AS Numeric(18, 2)), CAST(N'2022-05-29' AS Date))
GO
INSERT [dbo].[tblEmployee] ([Id], [Name], [Email], [Password], [Mobile], [Salary], [DOJ]) VALUES (9, N'Anil', N'saf@sdfsdf', N'4353535', N'798987989', CAST(25000.00 AS Numeric(18, 2)), CAST(N'2022-06-30' AS Date))
GO
SET IDENTITY_INSERT [dbo].[tblEmployee] OFF
GO
SELECT *
FROM tblEmployee
WHERE MONTH(DateAdd(Day,1,DOJ))<>MONTH(DOJ)
Output of above query is-
