Home » RDBMS Server » Server Administration » Re: @corelated subquery
Re: @corelated subquery [message #370984] Fri, 28 July 2000 15:50
Priyadarshini
Messages: 10
Registered: July 2000
Junior Member
Hope this is what you are expecting.

SELECT *
FROM emp a
WHERE 4 >= (SELECT COUNT(DISTINCT emp_no) FROM emp b where b.emp_no >= a.emp_no)
order by salary desc;
Previous Topic: Representing a BOOLEAN style FLAG (or simillar) in a table column?
Next Topic: Is it possible in a single Select Statement.?!
Goto Forum:
  


Current Time: Tue Oct 20 10:18:57 CDT 2020