get the last insert entered sql

What I understand is that, for a particular route, you want to return the record with the most recent date. If this is what you want, you can use TOP 1 combined with ORDER BY for column fecha .

select top 1 *
  from tabla
 where nombre_ruta = 'valor_ruta'
 order by fecha desc

Here I leave you other options that you can use also using subqueries, or window function row_number() . But the option with TOP 1 is the simplest:

select *
  from tabla t
 where t.nombre_ruta = 'valor_ruta'
   and t.fecha = (select max(t2.fecha)
                    from tabla t2
                   where t2.nombre_ruta = t.nombre_ruta)

select t.*
  from (select t.*,
               row_number() over (order by t.fecha desc) as rn
          from tabla t
         where t.nombre_ruta = 'valor_ruta') t
 where t.rn = 1

You can get it with

SELECT @@IDENTITY

This will bring you the last Id inserted

Try something like this:

SELECT TOP 1 FROM TU_TABLA WHERE NOMBRE_RUTA="RUTA1" ORDER BY FECHA DESC

With this query you get a record TOP 1 of TU_TABLA where the RUBBER NAME is equal to the name of the route you need which is ordered by the DATE of signing down, from highest to lowest.