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
Explain filtered indexes benefits?
Explain the difference between functions and stored procedures in sql server?
What are the difference between primary keys and foreign keys?
Do you know what are various aggregate functions that are available?
Will the writetext statement activate a trigger?
How do you delete a trigger?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What is unique key constraint?
What information is maintained within the msdb database?
What is difference between aggregate and analytic function?
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 does it mean to normalize a database and why would you do it?
Can sql servers linked to other servers?
What is log ldf?
