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

Explain how to use linked server?

992

Detail about the hardware which is supported by SQL server?

1063

What is a dataset and what are the different types of datasets?

136

what is an index? : Sql server database administration

983

What is faster join or union?

1213

Explain different types of self contained sub query?

1041

What are the database objects? : SQL Server Architecture

1052

How to call stored procedure using http soap?

1079

What are the five major components of a dbms?

929

How do you improve the performance of a SQL Azure Database?

137

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1059

How to make a remote connection in a database?

977

How to automatically create a log when an exception is being received into SQL Server?

1289

why would you use sql agent? : Sql server database administration

1215

What is the recovery model?

992