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;

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 06:42:26 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.