Test_Omega

SELECT TOP (1) WITH TIES card_id, shop_id
FROM [dbo].[cheques]
ORDER BY ROW_NUMBER() OVER (PARTITION BY card_id ORDER BY sale_date_id ASC, sale_time_id ASC);