Hi itsme,
Refer below sample query.
SQL
DECLARE @tblJob AS TABLE(Id INT,
Jobtitle VARCHAR(50),
Company_Name VARCHAR(50),
Salary VARCHAR(50),
Skills VARCHAR(50),
Qualification VARCHAR(50),
Details VARCHAR(MAX),
Experience VARCHAR(50),
email VARCHAR(MAX),
location VARCHAR(50),
Last_Apply_Date DATE,
City VARCHAR(50),
Age VARCHAR(50)
)
INSERT INTO @tblJob VALUES(4,'IT Job','company','2000','Asp.Net C#','Graduate','Good command on web development in asp.net c#','2 year','company@gmail.com','anand','10/12/2019','Anand','24')
INSERT INTO @tblJob VALUES(6,'IT Jo2','company','2000','Android','Graduate','Good command on Adnroid app development','2 year','company@gmail.com','anand agriculture university','8/30/2019','Ahmedabad','21')
INSERT INTO @tblJob VALUES(7,'test job','company','5000','Android','Masters','Good command on Adnroid app development','7 year','company@gmail.com','anand agriculture university','8/31/2019','Rajkot','22')
INSERT INTO @tblJob VALUES(10,'date check job2','company','13000','PHP','Masters','Good command on web app development','2 Year','company@gmail.com','anand agriculture university','8/21/2019','Gandhinagar','23')
SELECT Skills, Qualification ,Last_Apply_Date FROM @tblJob
WHERE CONVERT(DATE,Last_Apply_Date)>=CONVERT(DATE,GETDATE())
Output
| Skills |
Qualification |
Last_Apply_Date |
| Asp.Net C# |
Graduate |
12.10.2019 00:00:00 |
