There is a table with Pluks(‘plk’) and Zinks (‘zin’). Each Pluk onlyresides on a single Zink and each Zink may contain multiple Pluks. Howdo you find how many Pluks are on each and every Zink? Please provide SQL.

  • Interview Candidate
  • 9
  • 1919

Showing Answers 1 - 9 of 9 Answers

Aparna

  • Nov 30th, 2006
 

Is this correct?

let table name = PZ with Plk and Zlk as two attributes.

select count*(plk) / count*(zlk)

from  PZ

  Was this answer useful?  Yes

ualike

  • Dec 5th, 2006
 

Here it is, considering plk and zin are two attributes of a table zp)SELECT COUNT(*) as "Pluks"FROM zpGROUP BY zin;

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions