select * from table where date between GETDATE()-(5*365) and GETDATE()

How will u get 5 years back record?

Question Posted / krishna mohan thamisetty

Answer Posted / krishna mohan thamisetty

select *
from table
where date between GETDATE()-(5*365) and GETDATE()

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the language structure to add a record to a table?

1073

What are the types of database schema? : sql server analysis services, ssas

1180

What is a with(nolock)?

1023

What does select 1 mean?

971

How can I know what locks are running on which resource?

992

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1098

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

1027

Your table has a large character field there are queries that use this field in their search clause what should you do?

920

Explain database normalization?

1264

Which language is supported by sql server?

1054

What is database replication?

1205

Is it safe to delete log files?

969

What is a transactions?

1082

How will you go about resolving deadlocks?

1028

Explain full-text query in sql server?

1050