Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
group by express
- Thread starter Bao
- Start date
petersJazz
Programmer
Example:
select orderno,sum(price)
from orderrow
where orderdate > date('2002-01-01')
group by sum(price)
having sum(price) > 1000
order by orderno;
This means:
get me all ordernumbers and sum of price in orderrow table with the limit that orderdate should be after 1 jan and the price sum is more than 1000. Sort on ordernumber.
Group by is used together with aggregate functions (sum, count, max, min, avg...).
select orderno,sum(price)
from orderrow
where orderdate > date('2002-01-01')
group by sum(price)
having sum(price) > 1000
order by orderno;
This means:
get me all ordernumbers and sum of price in orderrow table with the limit that orderdate should be after 1 jan and the price sum is more than 1000. Sort on ordernumber.
Group by is used together with aggregate functions (sum, count, max, min, avg...).
- Status
Similar threads
- Locked
- Question
- Locked
- Question