help to build SQL Query

[anantwakode]

Hi
I want to retrive records from table,
name value date
aaa 20 10/10/2005 10:10:20
bbb 20 10/10/2005 10:10:20
ccc 20 10/10/2005 10:10:21
ddd 20 10/10/2005 10:10:22
eee 20 10/10/2005 10:10:22
aaa 20 10/10/2005 10:10:22

i want the records with time difference 1,2.. minute or hour, or date

Tahnks,
Anant

[hspc]

i want the records with time difference 1,2.. minute or hour, or date difference from what ? the current time ?
What database do you use ?
Anyway..Check the DateDiff function in MSDN..