Selecting closest, non expired value
4994
Retrieving n rows per group
39628
SQL select only rows with max value on a column
155224
Selecting Non-existent Data With MySQL
6884
Select values that meet different conditions on different rows?
42491
How do I efficiently get "the most recent corresponding row"?
780
How group with min(date) and select an another column in the same table
2283
How to use LINQ to select object with minimum or maximum property value
140748
How to check if a date is in a given range?
20780
How to select only date from a DATETIME field in MySQL?
151628
query to select data between todays date as well as tomorrows date time upto specific time
83264
Get Max value and corresponding column
148559
Using the correct, or preferable, not equal operator in MySQL
86649
What's the most efficient way to select the last n rows in a table without changing the table's structure?
15736
How do I search events between two set dates inside WP?
83536
Get first non-null value per row
35285
Creating a NearestFunction that returns an index
10524
Find the number in an array that is closest to a given number