Need a query to list rows from the last 24 hours

hi all

what sql sintaxe query table this:

select * table1
date between , last 24 hours
-- order date --not sure if needed

or better yet,

where date between max(date) , last 24 hours

thank you

 

---

jcd

try:

  select fields from table1 where [date] between dateadd(hour, -24, current_timestamp) and current_timestamp  

---

for every expert, there equal , opposite expert. - becker's law


my blog

SQL Server  >  Getting started with SQL Server