Cisco Written Test Qs.(PL/SQL) :: Basic Concepts - Discussion
88 / 123
There is an employer table with key fields as employer number data in every n'th row are needed for a simple following queries will get required results.
ASelect A employee number from employee A , where exists from employee B where A employee no. = B employee having (count(*) mod n)=0
Bselect employee number from employe A, employe B where A employe number=B employ number group by employee number having(count(*) mod n=0 )
CBoth (a) & (b)
DNone of the above