Re: Assing rows to a table
From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 05/25/04
- Next message: M. Garcia: "Centura-Gupta 1.5 and Windows XP"
- Previous message: John: "Assing rows to a table"
- In reply to: John: "Assing rows to a table"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 25 May 2004 14:49:29 +0530
hi john,
if i understand you correctly you are looking for COMPUTE BY clause of
SELECT statement.
you can check the resultset of following query on northwind database.
use northwind
go
select b.customerid, a.unitprice
from [order details]a join orders b
on a.orderid =b.orderid
order by b.customerid
compute sum (a.unitprice ) by b.customerid
go
if this is not what you want pls post relevent table structure, sample
records, and expected result set out of it.Also specify whether you can
looking for in INSERT /UPDATE/SELECT statment.
-- Vishal Parkar vgparkar@yahoo.co.in | vgparkar@hotmail.com
- Next message: M. Garcia: "Centura-Gupta 1.5 and Windows XP"
- Previous message: John: "Assing rows to a table"
- In reply to: John: "Assing rows to a table"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
