Forum OpenACS Q&A: Response to SQL tip: Find NEXT in Result

Collapse
2: Response to SQL tip: Find NEXT in Result (response to 1)
Posted by David Walker on 04/16/02 04:17 PM
You have already order the list by name. Now just select where name > current name. For example: 
select user_id,first_names
 from users
 where upper(first_names) > upper('Bob')
 order by upper(first_names)
 limit 1