How to find the date of the previous order and before the previous order?

Question

SQL Server

I can not find the location of the date of the previous order and before the previous order. There is 1 client and he has 3 orders. It is necessary to display the date of his order, the date of his previous order and the date of his previous order.

Answer 1

SELECT TOP(3) [DateOrder] FROM [Order] WHERE ([Client] = @ID) AND ([DateOrder] <= @DT)
  ORDER BY [DateOrder] DESC

Answer 2

select count(*) from orders where userId=42;  -- кол-во заказов

select count(*) from orders where userId=42 and date < "2021-10-05" ;  -- кол-во заказов до даты

select * from orders where usetId=42
ORDER BY date DESC -- сортировать по дате в обратном порядке
LIMIT 3; -- три последние записи