sorting data with aggregatefield in sql statement
From: Sudianto Atek (ijux_at_hotmail.com)
Date: 06/29/04
- Next message: Kevin Frevert: "Re: sorting data with aggregatefield in sql statement"
- Previous message: Jim Albertson: "Re: "Field cannot be updated" error with ADODataSet"
- Next in thread: Kevin Frevert: "Re: sorting data with aggregatefield in sql statement"
- Reply: Kevin Frevert: "Re: sorting data with aggregatefield in sql statement"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 29 Jun 2004 17:23:02 +0700
I have sql statement:
select Trans1.FLID, sum(PointFL) as JmlPoint, msFrontLiner.NmFrontLiner
from Trans1, msFrontLiner
where Trans1.FLID=msFrontLiner.FLID
group by Trans1.FLID, msFrontLiner.NmFrontLiner
order by JmlPoint Desc
How can I set order by "JmlPoint Desc" ?
- Next message: Kevin Frevert: "Re: sorting data with aggregatefield in sql statement"
- Previous message: Jim Albertson: "Re: "Field cannot be updated" error with ADODataSet"
- Next in thread: Kevin Frevert: "Re: sorting data with aggregatefield in sql statement"
- Reply: Kevin Frevert: "Re: sorting data with aggregatefield in sql statement"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]