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
Where cross join is used?
What are the different type of replication in sql server?
What is a raid and what are different types of raid configurations?
What are the two modes of authentication in sql server?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
Your table has a large character field there are queries that use this field in their search clause what should you do?
Explain following error properties?
What do you mean by collation recursive stored procedure?
What do you understand by mirroring and mention the advantages of the mirroring?
What is the use of stored procedure?
Write a program to fetch first 10 records from a file?
What is sql server programming?
Scalability, Availability, Integration with internet, etc.)?
What is the difference between varchar and varchar types?
What is deploy, process and build? : sql server analysis services, ssas