Re: [SQL] DIVISION with Group By

2008-12-09 Thread Richard Huxton
hdhgdh mjhff wrote: > Hai all, > > I am new to SQL coding. > I need some help in writing SQL > In my task i have to calculate division of two sub queries. > each sub query has its own group by clause. Can you provide a simpler example? It's not obvious to me what you're trying to do. -- Richa

[SQL] DIVISION with Group By

2008-12-01 Thread hdhgdh mjhff
Hai all, I am new to SQL coding. I need some help in writing SQL In my task i have to calculate division of two sub queries. each sub query has its own group by clause. Here with i have Paste my table information and my SQL. /* tdos table */ CREATE TABLE tdos ( dosid integer NOT NULL DEFAULT