The last reply is OK, but should read a.sal<b.sal to do what you need. Also it will possibly be inefficient on a large table. If you have any kind of procedural control you can try the simple, but obvious approach of
I've seen this question before. It was posted recently in SQL forum on 8/22/00 by Mackpei. I don't know if it will answer your question directly, but might give you a good starting point.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.