SQL Server 2016

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

CREATE table availability (
  Line int NOT NULL,
  date datetime NOT NULL,
  Vendor nvarchar(512) NOT NULL,
  Product_Name nvarchar(512) NOT NULL,
  Arrival_Time time not null
);

INSERT INTO availability (line,date,Vendor,Product_Name,Arrival_Time) VALUES
(1,'2020-09-01', 'Fruits Fruit Fuits','Bananas','2:30 PM')
,(2,'2020-09-01', 'Fruits Fruit Fuits','Apples','1:30 PM')
,(3,'2020-09-01', 'Fruits Fruit Fuits','Oranges','8:30 AM')
,(4,'2020-09-02', 'Fruits Fruit Fuits','Apples','3:30 PM')
,(5,'2020-09-02', 'Fruits Fruit Fuits','Oranges','12:30 PM')
,(6,'2020-09-02', 'Fruits Fruit Fuits','Bananas','4:30 AM')
,(7,'2020-09-01', 'Fruits & More','Bananas','9:30 PM')
,(8,'2020-09-01', 'Fruits & More','Apples','12:30 AM')
,(9,'2020-09-01', 'Fruits & More','Oranges','5:30 AM')
,(10,'2020-09-02', 'Fruits & More','Apples','11:30 PM')
,(11,'2020-09-02', 'Fruits & More','Oranges','3:30 PM')
,(12,'2020-09-02', 'Fruits & More','Bananas','1:30 AM')

;
SELECT * FROM  availability;

--Query should return these lines:
select * from availability where line in (1,4,7,10);

--This is what I thought would work, but now I realize that the product name would also be distinct
--but I don't know how to select just the date and vendor distinct but also get the product name

select distinct date,vendor,product_name, max(arrival_time) from availability
group by date, vendor, product_name

Line	date	Vendor	Product_Name	Arrival_Time
1	2020-09-01 00:00:00.000	Fruits Fruit Fuits	Bananas	14:30:00
2	2020-09-01 00:00:00.000	Fruits Fruit Fuits	Apples	13:30:00
3	2020-09-01 00:00:00.000	Fruits Fruit Fuits	Oranges	08:30:00
4	2020-09-02 00:00:00.000	Fruits Fruit Fuits	Apples	15:30:00
5	2020-09-02 00:00:00.000	Fruits Fruit Fuits	Oranges	12:30:00
6	2020-09-02 00:00:00.000	Fruits Fruit Fuits	Bananas	04:30:00
7	2020-09-01 00:00:00.000	Fruits & More	Bananas	21:30:00
8	2020-09-01 00:00:00.000	Fruits & More	Apples	00:30:00
9	2020-09-01 00:00:00.000	Fruits & More	Oranges	05:30:00
10	2020-09-02 00:00:00.000	Fruits & More	Apples	23:30:00
11	2020-09-02 00:00:00.000	Fruits & More	Oranges	15:30:00
12	2020-09-02 00:00:00.000	Fruits & More	Bananas	01:30:00

Line	date	Vendor	Product_Name	Arrival_Time
1	2020-09-01 00:00:00.000	Fruits Fruit Fuits	Bananas	14:30:00
4	2020-09-02 00:00:00.000	Fruits Fruit Fuits	Apples	15:30:00
7	2020-09-01 00:00:00.000	Fruits & More	Bananas	21:30:00
10	2020-09-02 00:00:00.000	Fruits & More	Apples	23:30:00

date	vendor	product_name	(No column name)
2020-09-01 00:00:00.000	Fruits & More	Apples	00:30:00
2020-09-01 00:00:00.000	Fruits & More	Bananas	21:30:00
2020-09-01 00:00:00.000	Fruits & More	Oranges	05:30:00
2020-09-01 00:00:00.000	Fruits Fruit Fuits	Apples	13:30:00
2020-09-01 00:00:00.000	Fruits Fruit Fuits	Bananas	14:30:00
2020-09-01 00:00:00.000	Fruits Fruit Fuits	Oranges	08:30:00
2020-09-02 00:00:00.000	Fruits & More	Apples	23:30:00
2020-09-02 00:00:00.000	Fruits & More	Bananas	01:30:00
2020-09-02 00:00:00.000	Fruits & More	Oranges	15:30:00
2020-09-02 00:00:00.000	Fruits Fruit Fuits	Apples	15:30:00
2020-09-02 00:00:00.000	Fruits Fruit Fuits	Bananas	04:30:00
2020-09-02 00:00:00.000	Fruits Fruit Fuits	Oranges	12:30:00