selecting unique records
Posted: Wed Sep 14, 2005 12:21 am
I've got a database table named 'sales' where each sale has these fields:
id, item,price,salesperson
table looks like:
1 item1 2.00 bob
2 item2 3.00 bob
3 item3 4.00 bob
I want to display:
how do I write the query?
Any help appreciated..
thanks.
mc
id, item,price,salesperson
table looks like:
1 item1 2.00 bob
2 item2 3.00 bob
3 item3 4.00 bob
I want to display:
Code: Select all
---------------------
|salesperson | total |
---------------------
| bob | 9.00 |
----------------------Any help appreciated..
thanks.
mc