select * from table1 where date between dateadd(yy,- 5,getdate()) and getd

How will u get 5 years back record?

Question Posted / tp

Answer Posted / tp

select * from table1 where date between dateadd(yy,-
5,getdate()) and getdate()

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is trigger explain with program?

930

How to create a store procedure with encryption?

950

What is a self join in sql server?

1054

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

850

Explain raiserror in sql server?

961

How can we use ConnectorJ JDBC Driver with MS SQL?

950

What is the server name in sql server?

956

What is the difference between clustered index and primary key?

869

What are trace flags and mention a few common trace flags used with sql server?

1035

How to verify a login name with sqlcmd tool?

1136

Why do we need normalization?

875

What are the differences between triggers and stored procedures?

989

Define Unique Key?

941

What stored by the msdb? : sql server database administration

951

Define full outer join?

891