How to get list of string for particular condt

[visweswaran2830]

hi,

let consider,

A table has following fields,

name
amount
date

I know to get sum of amount based for particular date

condition be..

select sum(amount) as val from table_name where date='06-16-2010'

Same as I want to get list of name for a particular date.

How can I achieve this..