Sort by position of edited record (sql server)

Question

When I enter a new record, I make an ordination where I sort by the last entered record.

SELECT TOP(50) * FROM TB_CLIENTE_FORNECEDOR where status <> 'S' order by IDCLIENTEFORNECEDOR desc

If I am editing a record of whose id is 10, I want to sort by this id.

Answer 1

Specify the value of ID as part of your inquiry, and use the Less than or Equal to (<=):

SELECT TOP(50) * 
FROM   tb_cliente_fornecedor 
WHERE  status <> 'S' 
  AND  idclientefornecedor <= 10
ORDER  BY idclientefornecedor DESC 

Reference:

https://msdn.microsoft.com/en-us/library/ms174978.aspx