Hi
Can I use a WHERE clause to limit the sql process? I means:
select empno, ename
from emp p1
where deptno not = 12
inner join
(select empno, max(empno)
from emp p2
group by empno) grouemp
ON p1.empno= gouemp.empno
You should not just choose any comment at random, ID: 41001026 does not offer a solution to your original question.
If your problem was solved by expert comments BEFORE ID: 41001025 then you should choose one or more of those comments.
Ryan Chong
Agreed with Paul on the principle of accepting a comment as the answer. Am already put a comment earlier in the "request an attention" relating to this issue.
Enrique Gomez Esteban
ASKER
Sorry for any incovenience. I opened this question and I got several helpful anwers but I could not check it properly at the moment so the question remains opened several months. I just was trying to close it. Thanks for your support.
Well,
I think I have already explained that that the question was not enough detailed and of course the answer also lack of this detail. As it was my fault because this issue that was very specifi c was removed from the backlog I could not give the right detail. Thats is why I tried to DELETE the question (sure I did something wrong) and I insist on the question unfortunately was not detailed properly and of course the answer is not detailed enough or is not addressing the right question and documentation.
That's is whiy I think a grade=B is right.