Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-22 : 23:36:41
|
| Jon writes "Suppose I have a field whose values are unique and numeric, but not necessarily sequenial (Autonumbered field after some values are deleted). Let's say the numbers in this field are 1,2,5,8,9,10,13. I'm looking at the row with field value 5. Without knowing the next number, can I return the first row with value greater than 5?" |
|
|
|
|
|
Returning only the first record whose value is at least n