Data fetching from table

Question

Hi ,

I have table with list of product columns and its ordered users for specific dates

so I need a sql query to fetch the group the products with specific to each user for the respective given date

For ex:             

Product	user	date
Soap	User 1	12-12-2008
Shampoo	User 1	12-12-2008
Tv	User 2	12-12-2008
Stool	User 2	12-12-2008

so I pass the date alone (12/12-2008)-- it should group the products according to user and show

 

  Thanks