This SQL code retrieves the nth Maximum and nth Minimum values in the column specified in <COLUMNNAME> from the table <TABLENAME>.
The argument will be accepted in the runtime by SQL:
To find the Nth Max:
SELECT * FROM <TABLENAME> a WHERE &N = (SELECT count(DISTINCT
(b.<COLUMNNAME>)) FROM <TABLENAME> b WHERE
a.<COLUMNNAME><=b.<COLUMNNAME>);
To find the Nth Min
SELECT * FROM <TABLENAME> a WHERE &N = (SELECT count(DISTINCT
(b.<COLUMNNAME>)) FROM <TABLENAME> b WHERE
a.<COLUMNNAME>>=b.<COLUMNNAME>);
If you have a hot tip and we publish it, we'll pay you. However, due to accounting overhead we no longer pay $10 for a single tip submission. You must accumulate 10 acceptable tips to receive payment. Be sure to include a clear explanation of what the technique does and why it's useful. If it includes code, limit it to 20 lines if possible.
Submit your tip here.
