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

Explain how does the report manager work in ssrs?

937

Explain security with sql azure?

186

Explain what is lock escalation and what is its purpose?

918

What are binary string data types in ms sql server?

1253

Explain time data type in sal server 2008?

909

How to use go command in "sqlcmd"?

1184

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1122

What function does a database engine serve in the sql server?

1021

How to convert numeric values to integers in ms sql server?

1062

What are the filtered indexes?

1018

What is a virtual table in sql?

976

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

310

How do indexes help, types?

938

What is a benefit of using an after insert trigger over using a before insert trigger?

967

Explain various data region available in ssrs with their use?

909