User:Srinimf/Srinimf
 | This is not a Wikipedia article: It is an individual user's work-in-progress page, and may be incomplete and/or unreliable. For guidance on developing this draft, see Wikipedia:So you made a userspace draft. Find sources: Google (books · news · scholar · free images · WP refs) · FENS · JSTOR · TWL |
Srinimf | Tech.Jobs.Biz.Success
Query to get latest date:
Select item, max(inventorydate) from table where inventorydate is < ‘6/30/2011′
Query to retrieve not more than 6 years from application date:
Select item from table
where appl_date >= (Currentdate – 6 Years)
Selecting date between two dates:
WHERE CP.ActionDate BETWEEN '19/12/2012' AND '1/17/2013'
References
[edit]External links
[edit]