Respected Members
I am having a table and there are 5 columns in it.
columns-- name, age, partyname, date, no
their values
aaa,22,super,05/05/2006,23
bbb,34,super,06/06/2006,98
ccc,21,dive,02/02/2006,78
ddd,21,live,04/04/2006,67
xxx,22,super,05/04/2006,28
now i want to retrieve data
when partyname=super and date >=05/04/2006 and date <= 05/05/2006
How can i write Query for that please help me.