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
What number sorts of privileges are accessible in sql?
What are the types of dml?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is autocommit mode in sql server?
What is the difference between deallocate cursor and close cursor?
Do you know clustered and non-clustered index?
What is mean by dml?
what changed between the previous version of sql server and the current version? : Sql server database administration
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
Which data type columns are the best candidates for full-text indexing?
What is ms sql server reporting services?
What does it mean to normalize a database and why would you do it?
Explain features of analysis services?
Is the order of columns in the set clause important in ms sql server?
What are different types of subquery?