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 database replicaion? : Sql server database administration

1271

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4459

Disadvantages of the indexes?

1184

How can you tell if a database object is invalid?

1116

What to check if a User database is locked?

1116

How adventureworkslt tables are related?

984

How you can move data or databases between servers and databases in sql server?

1101

What the different components in replication and what is their use?

998

What are 3 ways to get a count of the number of records in a table?

1122

What are various ways to enhance the ssrs report?

1033

What is the difference between char and varchar2 datatype in sql?

1124

How to create a view using data from another view?

997

How do I install sql server?

937

Explain about service Broker functions?

1089

Mention what are the different types of ssrs reports?

158