Why doesn't select min(empno) work for you? What does a min or max function do you for you behind the scenes? Umm, sort? According to your original post, you want the first sorted row. Well, gee, if they're sorted, what do you think the minimum would be? The first row?