I want to do an SQL query. The 'where' clause uses 'greater-than' a target value. I want to retrieve exactly one and only one row, namely, the very row exactly after my target value. The catch is, I want it to be efficient; I don't want the select to find hundreds of records first, then serve up the single row I want; I want it to find the row I want (reminder: it's already an indexed row). Can SQL do this, and do it efficiently like an ISAM read would do?
2006-07-28
07:32:08
·
3 answers
·
asked by
Tony
1
in
Programming & Design