Dividing two Count(*)'s ??

From: Fernando Borcel <fb_at_overnet.com.ar>
Date: 1996/08/01
Message-ID: <32002C31.5673_at_overnet.com.ar>#1/1

How do I perform a query that returns the division between the count of two tables?

That is to say:

Select count(*) / (Select count(*) from Tb2) from Tb2;

Fernando Borcel Received on Thu Aug 01 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: John Homeyard: "Re: Dividing two Count(*)'s ??"
Previous message: Johnny A. Wedekind: "raw space vs unix filesystem"
Next in thread: John Homeyard: "Re: Dividing two Count(*)'s ??"
Reply: John Homeyard: "Re: Dividing two Count(*)'s ??"
Reply: Thomas J. Kyte: "Re: Dividing two Count(*)'s ??"
Reply: Bill Schoonmaker: "Re: Dividing two Count(*)'s ??"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message