Let's say that I have the following integer values in a table
32 11 15 123 55 54 23 43 44 44 56 23
OK, the list can go on; it doesn't matter. Now I want to query this table and I want to return a certain number of
closest records. Let's say I want to return 10 closest record matches to the numer 32. Can I achieve this efficiently?
It is in SQL Server 2014.