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
Explain steps of normalization?
Explain what is the purpose of sql profiler in sql server?
What is sql server used for?
Do you know how to send email from database?
What happens if null values are involved in boolean operations?
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?
What is correlated subquery in sql server?
How to send email from database?
What is the sql case statement used for?
How do I install only the client tools of sql server 2000?
System variable and temporary variables
How many columns can we include on clustered index ?
How do I completely remove sql server instance?
What is page in sql server?
What is a covering index?