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

can an automatic recovery be initiated by a user? : Sql server administration

956

What are magic tables in sql server?

1135

What are user defined functions in ms sql server?

1000

When we should use and scope of @@identity?

999

How does using a separate hard drive for several database objects improves performance right away?

934

Write a SQL query to make a column as unique?

1041

How do I make a resultset scrollable?

962

Do you know how to send email from database?

1005

What is best institute to Learn DotNET And SQL in chennai?

2163

Why do we need different type of parameter?

1058

How to locate and take substrings with charindex() and substring() functions?

1016

Explain what is the difference between a local and a global temporary table?

1003

What command do we use to rename a db, a table and a column?

927

How many types of schemas are there?

1042

How to concatenate two strings in SQL Server.

1150