how to display last 10 days data
ex 1 user login and many frnd rqst received . some rqust accepted different date
21/10/21, 25/10/21, 10/11/21, 12/11/21, 15/11/21, 20/11/21, 28/11/21.
i want output last 10 frnd rqst accepted display
create table tblfrequst(f_id int identity(1,1),to_id int, from_id int,date varchar(100),date_time varchar(50),rqaccepted_time varchar(50),rqaccepted_date varchar(20),request_status VARCHAR(10))
INSERT INTO tblfrequst VALUES(8,16,17-09-2020,9/17/2020 9:33:27 PM,06:54:13:PM,20-09-2020,'AC')
INSERT INTO tblfrequst VALUES(9,16,17-09-2020,9/17/2020 9:33:27 PM,06:54:13:PM,06-11-2020,'AC')
INSERT INTO tblfrequst VALUES(19,17,17-09-2020,9/17/2020 9:33:27 PM,06:54:13:PM,20-10-2020,'AC')
INSERT INTO tblfrequst VALUES(5,16,17-09-2020,9/17/2020 9:33:27 PM,06:54:13:PM,08-10-2020,'AC')
INSERT INTO tblfrequst VALUES(10,17,17-09-2020,9/17/2020 9:33:27 PM,06:54:13:PM,28-10-2020,'AC')
INSERT INTO tblfrequst VALUES(17,16,17-09-2020,9/17/2020 9:33:27 PM,06:54:13:PM,20-11-2020,'AC')
