Find closest numeric value in database

by

get the difference between the area and your input, take absolute value so always positive, then order ascending and take the first one

SELECT TOP 1 * FROM [myTable] 
WHERE Name="Test" and Size = 2 and PType="p"
ORDER BY ABS( Area - @input )

More Related Contents:

  1. SQL is null and = null [duplicate]
  2. Aggregate columns with additional (distinct) filters
  3. Reset identity seed after deleting records in SQL Server
  4. How to avoid the “divide by zero” error in SQL?
  5. SQLite Reset Primary Key Field
  6. Multiple INSERT statements vs. single INSERT with multiple VALUES
  7. Using an ORM or plain SQL? [closed]
  8. Database Structure for Tree Data Structure [closed]
  9. sql ORDER BY multiple values in specific order?
  10. Dynamic SELECT TOP @var In SQL Server
  11. MySQL’s now() +1 day
  12. CREATE TABLE IF NOT EXISTS equivalent in SQL Server [duplicate]
  13. Query to get records based on Radius in SQLite?
  14. Select a random sample of results from a query result
  15. Google spreadsheet “=QUERY” join() equivalent function?
  16. How can I include null values in a MIN or MAX?
  17. PostgreSQL ORDER BY issue – natural sort
  18. Get month name from date in Oracle
  19. How do I import .sql files into SQLite 3?
  20. How to get the size of a varchar[n] field in one SQL statement?
  21. SQL Server Update Group by
  22. Query for getting value from another record in same table and filter by difference greater than a gap threshold
  23. Closing connection when using Dapper
  24. SQL CREATE LOGON – can’t use @parameter as username
  25. How do I format date and time on ssrs report?
  26. In Oracle, is it possible to INSERT or UPDATE a record through a view?
  27. SELECT max(x) is returning null; how can I make it return 0?
  28. SQL INSERT INTO from multiple tables
  29. Retrieve Oracle last inserted IDENTITY
  30. RegEx to Detect SQL Injection

Leave a Comment