How will u get 5 years back record?

Answer Posted / tp

select * from table1 where date between dateadd(yy,-
5,getdate()) and getdate()

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain steps of normalization?

723


Explain what is the purpose of sql profiler in sql server?

749


What is sql server used for?

731


Do you know how to send email from database?

733


What happens if null values are involved in boolean operations?

740






what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

733


What is correlated subquery in sql server?

748


How to send email from database?

757


What is the sql case statement used for?

759


How do I install only the client tools of sql server 2000?

738


System variable and temporary variables

1905


How many columns can we include on clustered index ?

677


How do I completely remove sql server instance?

780


What is page in sql server?

689


What is a covering index?

723