How will u get 5 years back record?

Answer Posted / krishna mohan thamisetty

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

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where cross join is used?

710


What are the different type of replication in sql server?

757


What is a raid and what are different types of raid configurations?

881


What are the two modes of authentication in sql server?

711


Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

131


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

713


Explain following error properties?

750


What do you mean by collation recursive stored procedure?

809


What do you understand by mirroring and mention the advantages of the mirroring?

809


What is the use of stored procedure?

695


Write a program to fetch first 10 records from a file?

784


What is sql server programming?

791


Scalability, Availability, Integration with internet, etc.)?

2628


What is the difference between varchar and varchar types?

769


What is deploy, process and build? : sql server analysis services, ssas

787