I have monthly revenue tables; with a new one created every month.
SELECT * FROM sampledb.revenue_201106;
SELECT * FROM sampledb.revenue_201105;
SELECT * FROM sampledb.revenue_201104;
I'd like to query only the last two month's tables. Is there a "smart" way to select these tables only?
i.e...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.