Serial key for max recorder 1.026 - BSRSoft BSR Screen Recorder

This is good really for SQL Server, Oracle, or anything that can handle SQL.

Most hacks know about MAX(), as in:

SELECT MAX(col_name) FROM table

So if the column has a max value in it of 10, you get 10 back. But what if you want the highest value in the column that is less than a certain amt.? This for example is good for getting back the next most recent record when col_name is an incrementing key column and you want to exclude the most recent record (ID'd by it having the current maximum value key) in the column. Now you are faced with writing an SP or egad, traversing a recordset client-side. Ugh.

Here's the fix:

SELECT MAX(col_name) FROM table WHERE col_name < {some_value}

This works. It works even when the key column is not guaranteed to have continuous sequential values, such as when records are added and deleted over time and the key values assigned all stay the same (which is what happens in 99.9999999+% of all cases).

Have fun.

Homework: Haven't tried it but I am betting you can also do this:

SELECT MAX(col_name) FROM table WHERE col_name < MAX(col_name)

Whoa... well, try it and see if it works. Some SQL interpreters don't like aggregation/sub-computational functions on the right side of the comparator. In that case, you'd get MAX(col_name) first with a simple SELECT stmt., assign it to a variable, then use that variable as the right hand side modifier for the '<' comparitor.

Seems simple, right? But oh, the pain these kinds of situations cause. Hope this helps some of y'alls.