Interested to Buy Any Domain ? << Click Here >> for more details...
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
Can we add a cpu to sql server?
Differentiate between a having clause and a where clause.
What are trace files?
What samples and sample databases are provided by microsoft?
Explain following error properties?
Why I can not enter 0.001 second in date and time literals in ms sql server?
What is database dimension? : sql server analysis services, ssas
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
what is the difference between openrowset and openquery?
What is the order in which the sql query is executed?
What are the steps you can take to avoid “deadlocks”?
Does order by actually change the order of the data in the tables or does it just change the output?
Explain cross join or cartesian product in sql?
Is the order of columns in the set clause important in ms sql server?
query processing
