Link to home
Create AccountLog in
Avatar of newtoperlpgm
newtoperlpgmFlag for United States of America

asked on

SQL Server query last seven days

I need to query a SQL Server table to find records that have been entered within the last seven days.  I am new to SQL Server.  Thanks.

select column1, column2, column3
from mytable1
where ?
SOLUTION
Avatar of dbaSQL
dbaSQL
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Avatar of YZlat
YZlat
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of newtoperlpgm

ASKER

perfect, thank you.