Get data for last 5 hours

[nelco]

Hi,
I have a date time field in a table, and based on this field, I want to get the data for the last 5 hours. Any idea on how to accomplish this?

Any help would be appreciated.
Thanks!

 

[RiverGuy]

SELECT * FROM YourTable
WHERE YourDateTimeColumn >= DATEADD(hour, -5, GETDATE())

 

[nelco]

Thanks Riverguy. It worked.
I have one more question:
The columns that I am interested in a table are:
Deal_No. Deal_Date
If I have to count the Deal_No. for every min(In Deal_Date), how can this be done?

 

[RiverGuy]

By "min," do you mean minute, or MIN as in the SQL Server MINIMUM function?

 

[gmmastros]

nelco,

Do you want to show 0's? I mean... if there are no rows for 8:40 AM, should that row be omitted from the results, or do you want to see the row with a count of 0?




-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[nelco]

0's are fine(they should be part of results). Thanks George for your help.

 

[nelco]

River guy, I meant minute

 

[RiverGuy]

Nevermind, I answered in your other thread. To use zero's, you're going to have to use a static table to join on or a derived/temporary table or variable.